Timestamps

M

Mike

How can I automatically insert the current time/date in a
field when a new record is created? Thanks.
 
C

chriske

Mike a formulé ce zondag :
How can I automatically insert the current time/date in a
field when a new record is created? Thanks.
Click to expand...

just add date() or now() as standard value in an empty unused date
field wich cannot be edited in your application GUI

grtz
 
D

Douglas J. Steele

Add a CreateDt field to your table, and set its default value to Now() (if
you want the date and time) or Date() (if you only want the date)
 
Top