Access 97 Date Format Different on PCs

  • Thread starter Thread starter JB
  • Start date Start date
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
 
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
 
Back
Top