For example, you can combine the General Date and Long Time formats as follows: m/dd/yyyy;h:mm:ss.
If the value does not have a time component, Access displays only the date.
If the value has no date component, Access displays only the time.
Any short string of characters, enclosed in quotation marks ("") is a custom separator.
It’s social networking for people you haven’t met yet.
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.The display format that you select will not affect how the data is entered or how Access stores that data.For example, you can enter a date in a European format such as , and have the table, form, or report display the value as 11/28/2006.For example, if you applied an input mask to enter dates in the European format, someone entering data in your database will not be able to enter dates in other formats.Input masks can be applied to fields in tables, query result sets, and to controls on forms and reports.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.