Access 97 Date Format Different on PCs

J

JB

I have a query inside an Access 97 database that returns a date. When the
query is executed from computer A it returns 02/11/04. When the same query
is executed from computer B it returns 2/11/04. What file(s) do I need to
update on computer B so it adds the leading zero to the date format?

I am aware I can insert a format command to add the leading zero, but
currently don't have the time to track down all the instances where it would
be needed.

Thanks
 
A

Allen Browne

By default, Access displays dates as defined in the Windows Control Panel
under Regional Options. For leading zeros and 4-digit year, set Short Date
there to:
mm/dd/yyyy
 
Top