Date Format In Microsoft Access

This article has been archived. It is offered "as is" and will no longer be updated.
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

Artikelnummer: 869174 – Letzte Überarbeitung: 01/07/2015 23:46:32 – Revision: 3.0

  • kbnosurvey kbarchive kbmbsmigrate kbretire KB869174