Date Format In Microsoft Access

Article ID: 869174
Expand all | Collapse all

TechKnowledge Content

Question: When I look at the date fields of the Dynamics tables Microsoft Access, they are in a DD-MM-YY format. How can it be changed to show the MM-DD-YY format.

Answer: This change needs to be done in the Regional Settings Properties window (Start - Settings - Control Panel - Regional Settings). The date format in Access if reflected based on what is showing in regional settings. Once the proper date format is applied in the regional settings, the desired format will show in Access.

This article was TechKnowledge Document ID: 18520


Article ID: 869174 - Last Review: October 15, 2011 - Revision: 3.0
kbmbsmigrate kbretire KB869174
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from