access system date format

  • Thread starter Thread starter balu
  • Start date Start date
B

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