Article ID: 869174
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