Validating date format

Use the separator defined in the Windows regional settings.

For information about those settings, see the section, Change the Windows regional settings to change how dates and times are displayed.

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.

(Default) Displays date values as numbers and time values as hours, minutes, and seconds followed by AM or PM.

For more information about how to calculate date values, see the article on the Date function.

For example, If you enter an invalid date, such as , a message appears and you would have the option of entering a new value or converting the field from the Date/Time data type to the Text data type. The settings for date or time fields always resides in a table, but the date or time value can be displayed in a table, form, or report.

Valid date values range from -657,434 (January 1, 100 A. You can also store the date and time values as numbers when you plan to perform calculations on the date and time data.

For example, you can combine the General Date and Long Time formats as follows: m/dd/yyyy;h:mm:ss.

Controls where Access places the separator for hours, minutes, and seconds.

Leave a Reply