How to use international date format. Access 2002

[Salo]

Im have a table with a date field and everytime I input a
date in changes it to US format. Anybody knows how to get
around this?

 

[Allen Browne]

A date typed into the user interface (e.g. a form) is interpreted in accord
with the setting in Windows Control Panel | Regional Settings.

A literal date in VBA or in a SQL statement is interpreted as US format
(mm/dd/yyyy).

For information on how to avoid problems if your format is not the US one,
see:
International Dates in Access
at:
http://users.bigpond.net.au/abrowne1/ser-36.html

 

[Salo]

Thank you.. Ill check it out...

-----Original Message-----
A date typed into the user interface (e.g. a form) is interpreted in accord
with the setting in Windows Control Panel | Regional Settings.

A literal date in VBA or in a SQL statement is interpreted as US format
(mm/dd/yyyy).

For information on how to avoid problems if your format is not the US one,
see:
International Dates in Access
at:
http://users.bigpond.net.au/abrowne1/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")




.

 

[Douglas J. Steele]

Dates in Access aren't actually stored with a format: they're stored as 8
byte floating point numbers, where the integer part represents the date as
the number of days relative to 30 Dec, 1899, and the decimal part represents
the time as a fraction of a day.

In my opinion, it's unreasonable for you to force your users to use a
specific input format for the dates (and completely unacceptable to change
their settings). Let them enter the dates however they like. As long as it's
consistent with how their Short Date format has been set on their
workstation, it'll be stored in Access correctly. You can change how it's
displayed to them (and here's where it's okay to use a specific format) by
setting the field's Format property.