This article has been archived. It is offered "as is" and will no longer be updated.
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
Artikelnummer: 869174 – Letzte Überarbeitung: 01/07/2015 23:46:32 – Revision: 3.0