HOW TO INSERT DATE AUTOMATICALLY

[TX-Sales]

I am working on a invocie database. I need to know how to have the date
automatically inserted in the field. Right now it will insert the date of
today, but past records also chnage their dates to the urrent day. I need
them to stay the date as when each record was made and not update to the
current date.
Thanks

 

[Rick Brandt]

I am working on a invocie database. I need to know how to have the
date automatically inserted in the field. Right now it will insert
the date of today, but past records also chnage their dates to the
urrent day. I need them to stay the date as when each record was made
and not update to the current date.
Thanks

You need a field in the table [InvoiceDate] (for example) and set its
Default Value to =Date() or =Now() depending on whether you want to capture
the date only or the date and the time.