Today's date Formula recorded permanently in a datefield?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to record "=Now()" result permanently in a datefield?
I have users I need to ran report with date stamp the date/time they worked
on a project instead of them entering the date manually.

Thanks,
rcruz
 
Do a search for "timestamp" and you will find many posts explaining how to
mark the last time a record was modified.

Rick B
 
Is there a way to record "=Now()" result permanently in a datefield?
Click to expand...

Sure. Set the Default property of the table field, or of the form
textbox, to Now().

Note that Now() does NOT return "today's date". It returns the current
date and time from the system clock, accurate to microseconds. If you
really want the date without the time, use Date() instead.

This advice applies to creating new records in a table. If you want to
record when an existing record was modified post back - it's a bit
more work but quite doable.

John W. Vinson[MVP]
 
Back
Top