Date Format

[Ang]

Hi,

I'm trying to set the date format in one place. I don't know how to stay
all the same date like DD\MM\YY.

example:

I select the date : 06/08/2003 turn to 06-Aug-03 but if you use
08/06/2003 turn to 08-Jun-03. I just want to force all the format to use
DD\MM\YY.

I guess there is no way to do that. Your feedback would be very helpful.

Thanks,
Ang

 

[Allen Browne]

To set the date format for all your Windows programs including Access, open
the Windows Control Panel, go to Regional Options, and click the Date tab.

In Access, leave the Format property blank, or use one of the built-in
format such as Short Date or Medium Date.

That takes care of the interface (forms, query design).
However, in VBA code and in SQL statements, you must use the mm/dd/yy
format. Otherwise a line of code would not work the same all over the
planet.

For more information on how to avoid problems with you dd/mm format, see:
International Dates in Access
at:
http://allenbrowne.com/ser-36.html