How To Add a Date or Time Stamp to an Access 2010 Database Table

Add a Date or time stamp to an Access 2010 Database Table
Add a Date or time stamp to an Access 2010 Database Table. Mike Chapple

There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s easy to do this in Microsoft Access using the Now() function, in fact, it shouldn't take more than 5 minutes. In this tutorial, I explain the process step-by-step. 

Note: These instructions are for Microsoft Access 2010. If you are using an earlier version of Access, please see Adding a Date or Time to an Access Database.

Adding a Date or Time Stamp

  1. Open the Microsoft Access database containing the table to which you wish to add a date or time stamp.
  2. In the left window pane, double-click on the table where you would like to add a date or time stamp.
  3. Switch the table into design view by selecting Design View from the View drop-down menu in the upper left corner of the Office Ribbon.
  4. Click on the cell in the Field Name column of the first blank row of your table. Type a name for the column (such as “Record Added Date”) in that cell.
  5. Click the arrow next to the word Text in the Data Type column of the same row and choose Date/Time from the drop-down menu.
  6. In the Field Properties window pane at the bottom of the screen, type “Now()” (without the quotes) into the Default Value box.
  7. Also in the Field Properties pane, click the arrow in the cell corresponding to the Show Date Picker property and select Never from the drop-down menu.
  1. Save your database by pressing the disk icon in the upper left corner of the Access window.
  2. Verify that the new field works properly by creating a new record. Access should automatically add a timestamp to the Record Added Date field.

Tips:

  1. The Now() function adds the current date and time to the field. Alternatively, you may use the Date() function to add the date without the time.
    Format
    mla apa chicago
    Your Citation
    Chapple, Mike. "How To Add a Date or Time Stamp to an Access 2010 Database Table." ThoughtCo, Sep. 24, 2017, thoughtco.com/access-2010-database-table-date-stamp-1019924. Chapple, Mike. (2017, September 24). How To Add a Date or Time Stamp to an Access 2010 Database Table. Retrieved from https://www.thoughtco.com/access-2010-database-table-date-stamp-1019924 Chapple, Mike. "How To Add a Date or Time Stamp to an Access 2010 Database Table." ThoughtCo. https://www.thoughtco.com/access-2010-database-table-date-stamp-1019924 (accessed May 22, 2018).