On Wed, Mar 05, 2003 at 01:38:58PM -0500, Jeff Thies wrote:
>
>
> 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.
Did you try both sibgle and double quotes?
And maybe ... = {d '1999-9-30'} ?
Tim [who knows almost nothing about Access]
