HOW TO INSERT DATE AUTOMATICALLY

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

Guest

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
 
TX-Sales said:
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
Click to expand...

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.
 
Back
Top