SQLUPdate using DATES

  • Thread starter Thread starter Dickie
  • Start date Start date
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.?
 
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.?


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

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
 
Back
Top