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.

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top