Tim Bunce wrote: > > On Wed, Mar 05, 2003 at 02:36:50PM +0000, Volker I. Lipper wrote: > > Hi Jeff, > > > > the correct syntax in access itself would be: > > > > >#9/30/1999# > > > > the writing of the data (mm.dd or dd.mm or mm/dd) belongs to the > > system variables set on the system acess is installed on. But in > > every case you have to use the # sign. > > Doesn't using standard quotes work?
Nope, But the # does work. I'm sure I should have known that, but I normally save dates as unix times in a varchar. Jeff > > Tim.