Add a date or time stamp to new records

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?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.