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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Getting Month periods to show in ACCESS query as 0 when there is no data for the month 0
Using DateAdd and IIF conditions in a Query 2
Access 97, DATE() Function not working 3
Stored date is not being recognised 1
Selecting top 2 records on same row 4
Query date Parameter Anomaly 4
Automatically update all future dates when earlier date is entered 3
Date Format 1

Back
Top