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

 

[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!!