SQLUPdate using DATES

D

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.?
 
M

Marshall Barton

Dickie said:
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.?
Click to expand...


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).
 
D

Douglas J. Steele

Marshall Barton said:
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).
Click to expand...

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
 
Top