Format date and time values

The following table lists examples of expressions that use the Format function to convert date and time values to a format you specify.

You can use these expressions in calculated controls (calculated control: A control that is used on a form, report, or data access page to display the result of an expression. The result is recalculated each time there is a change in any of the values on which the expression is based.) on forms, reports, and data access pages (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.).

 Tip    Try Office 2010 In Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.
Watch a video or try Office 2010.

Expression Description
= Format(Now(), "hh:mm AMPM") If the current time is 5:04:23 in the afternoon, the expression returns 05:04 PM.
= Format(Now(), "Long Time") Returns current time in the system-defined long time format.
= Format(Now(), "h:m:s") If the current time is 8:04:23, the expression returns 8:4:23.
= Format(Date(), "dddd, mmm d yyyy") If the current date is 11/14/2003, the expression returns "Friday, Nov 14 2003".

You can use these expressions in a calculated field in a query.

Expression Description
TimeStamp: Format(Now(), "h:m:s") In the TimeStamp field, displays the time as 10:50:7, if the current time is 10:50:07.
DayAndDate= Format(Date(), "dddd, mmm d yyyy") Sets the DayAndDate field to "Tuesday, Dec 2 2003" if the current date is 12/02/2003.
Applies to:
Access 2003