Try without the ' around the date update trialno set harvestdate = 08/04/2008 where trial = '088741' Dan Goldberg
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Niehaus Sent: Monday, September 29, 2008 11:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Problem editing dates - not a valid date When I try to edit a date in a table by using a command like "Edit all in table where harvestDate = '01/01/01' I get a screen with records showing. When I try to edit the field harvestDate for one of the records, I get an error "07/31/2008" is not a valid date. I get the same problem when trying to edit a date in a form also (I'm not using a date picket). If I use the following command, it works fine with the database. update trialno set harvestdate = '08/04/2008' where trial = '088741' My input setting for date is set at DDMMYYYY. I just updated to 7.6.4.30919 Thanks. Bill Niehaus
