date question

  • Thread starter Thread starter Striker3070
  • Start date Start date
S

Striker3070

In A2007, I import data daily. the date field is not part of the import, nd
I want to auto fill that with yesterdays date. So something like Today(-1)
How do I get that field to auto poulate with yesterdays date
 
Hi,

Set the Default Value of the field to:

DateAdd("d",-1,Date())

or

Date()-1


Clifford Bass
 
Back
Top