Use current date and time in calculations

The following table lists examples of expressions that use the Date and Now functions to return the current date.

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
=Date() Displays the current date in the form of mm-dd-yyyy, where mm is the month (1 through 12), dd is the day (1 through 31), and yyyy is the year (1980 through 2099).
=Now() Displays the current date and time.
=Date() - 1 Displays yesterday's date.
=Year(Date()) Displays the current year.

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

Expression Description
TodaysDate: Date() Displays in the TodaysDate field the current date.
WhenRecorded: Now() Displays in the WhenRecorded field the current date and time.
Applies to:
Access 2003