Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    13

    Unanswered: Autovalue for date/time

    I would like to put date/time stamp to my data base, a field that would automatically add time and date when the new record was written into table?
    Even more, I would like one time for when new record was started, and one for the time when it was finished/saved for the first time.

    Best regards

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Easy

    You can create a date column in the table and set the default value to =Now(). When the record is created it will default to that date. The other is a little trickier and would require some coding behind the form to do a date difference between when the record is first created and when it is saved.
    --If its free, take it for what its worth!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •