S
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?
date in changes it to US format. Anybody knows how to get
around this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
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
S
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")
.
D
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.
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.