Today's date Formula recorded permanently in a datefield?

J

jrcruzr

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
 
R

Rick B

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

Rick B
 
J

John Vinson

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]
 
Top