Date Switches

[RhondaStockton]

Hi there
I have a user who is dealing with a database (Access 2003) where the dates are swopped whenever someone goes into it. 2004/01/10 is e.g. 2010/04/01. The regional settings are all set the same on the various PC's that have access to the database. My suggestion was to enforce an input mask. Do you have any other suggestions?
Thank you

 

[Andrew Fergus]

Hi, you could try using a custom date format in the underlying tables and on any forms and reports by setting the format to, for example, yyyy/dd/mm.
HTH, Andrew.