date question

[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

 

[Steve]

Go to your table in design view. Set the Default Valu of the date field to
Date()-1.

Steve
(e-mail address removed)

 

[Clifford Bass]

Hi,

Set the Default Value of the field to:

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

or

Date()-1


Clifford Bass