In the United States, you would see 11/28/2006 PM.It is possible to change these automatic formats by using custom display formats.Valid date values range from -657,434 (January 1, 100 A. The default format is the General Date format — m/dd/yyyy h:mm:ss AM/PM.
The characters consist of placeholders (such as 0 and #), separators (such as periods and commas), literal characters, and colors.
Custom formats for the Date/Time fields can contain two sections — one for the date and another for time — and you separate the sections with a semicolon.
Access automatically displays the date and time in the General Date and Long Time formats. For example, in Europe and many parts of Asia, depending on your location, you might see the date and time as PM or 28/11/2006 PM.
were mm is the month, dd is the day, and yyyy is the year.
When you use the Date/Time data type in Microsoft Access, you have the option to keep the default formats, apply a predefined format, or create a custom format. The time is displayed as, hh:mm:ss AM/PM, where hh is the hour, mm is minutes, and ss is seconds but you can display the date and time in several formats.