SQLUPdate using DATES

[Dickie]

Is there a function which will allow me to use the SQL Update code with the
DATE function and not have the data stored in my table in US format.?

 

[Marshall Barton]

Is there a function which will allow me to use the SQL Update code with the
DATE function and not have the data stored in my table in US format.?

Dates are stored as a double precision floating point
number, which is independent of any format.

If you're seeing the date displayed in US format, it's
because that's what is specified as a format property
somewhere (many possibilities).

 

[Douglas J. Steele]

Dates are stored as a double precision floating point
number, which is independent of any format.

If you're seeing the date displayed in US format, it's
because that's what is specified as a format property
somewhere (many possibilities).

I suspect Dickie's complaining that his SQL code doesn't work unless the
dates are in mm/dd/yyyy format.

Dickie: Check out http://www.mvps.org/access/datetime/date0005.htm at "The
Access Web"

You might also read Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html or what I have at
http://members.rogers.com/douglas.j.steele/SmartAccess.html

 

[Dickie]

Thanx, works like a dream.

I suspect Dickie's complaining that his SQL code doesn't work unless the
dates are in mm/dd/yyyy format.

Dickie: Check out http://www.mvps.org/access/datetime/date0005.htm at "The
Access Web"

You might also read Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html or what I have at
http://members.rogers.com/douglas.j.steele/SmartAccess.html