Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

In some Access tables, it is important to keep track of the date or the date and time when a new record is added. This is often referred to as a date or time stamp. You can use the Now function or Date function to have Access automatically fill in the date or time when a new record is added. Use the Now function to fill in the date and time, or the Date function to fill in just the date.

Add a date or time stamp field

  1. In the Navigation Pane, double-click the table to which you want to add the time stamp field.

    Access opens the table in Datasheet view.

  2. In the first blank column labeled Click to Add, select Date & Time from the drop-down list of data types. Access creates a new field and then displays a temporary field name.

  3. Type a name for the field, such as Date Added, and then press ENTER.

  4. Click File > Save, or press CTRL+S to save your table design changes.

  5. On the Home tab, in the Views group, click View, and then click Design View to switch to design view.

  6. In the Field Name column, select your new field.

  7. Under Field Properties at the bottom of the design view, on the General tab, click in the Default Value property box, and then type Now() or Date().

  8. Click the Show Date Picker property box, and then select Never from the list.

  9. Save your changes, and then close the table.

Each time you add a new record to the table, Access automatically inserts the date or the date and time in the Date Added field.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!