Home > DeveloperSection > Interviews > In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

Posted on    May-20-2011 2:39 AM

 MS Access MS Access 
 1 Answer(s)
  2773  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Posted on    May-20-2011 12:00 AM

In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.

Don't want to miss updates? Please click the below button!

Follow MindStick