access system date format

[balu]

dears,
in access 2000 format while programing on the forms i used dd/mm/yy date
format
( that is my system date format)
but where on the any new system with other system date format ( say mm /
dd/yy)
is causing major error how to set right with this please ?

 

[Allen Browne]

Access handles this automatically, according to the user's settings in the
Windows Control Panel under Regional Options.

If your regional options are dmy, then that's how the dates are presented to
you, and how Access interprets what you type in the user interface. If
another user's settings are mdy, that's how Access will display/interpret
theirs. Someone else has ymd, and Access will respect their settings also.

There are 3 cases where Access may not interpret the dates as you expect.
See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html