Date question

[ryan.fitzpatrick3]

I have a date field, I want to lookback 15 days from today for all
PO's, in the criteria what would I put in there? I know theres a
dateadd is there a datesubstract or something along the lines of that?
It will always be 15 days. Thanks

ryan

 

[raskew via AccessMonster.com]

I have a date field, I want to lookback 15 days from today for all
PO's, in the criteria what would I put in there? I know theres a
dateadd is there a datesubstract or something along the lines of that?
It will always be 15 days. Thanks

ryan

Two examples:

x = date() - 15

x = dateadd("d", -15, date())

HTH - bob

 

[Klatuu]

= DateAdd("d", -15, Date)

To subtract, just use a negative number

 

[ryan.fitzpatrick3]

Thanks, that was it, I knew it was something along the lines of that!!