Date question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryan.fitzpatrick3@safeway.com - 17 Apr 2008 18:53 GMT

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

Reply to this Message

raskew - 17 Apr 2008 19:56 GMT

>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

Reply to this Message

Klatuu - 17 Apr 2008 19:58 GMT

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

To subtract, just use a negative number

Signature

Dave Hargis, Microsoft Access MVP

> 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

Reply to this Message

ryan.fitzpatrick3@safeway.com - 17 Apr 2008 22:04 GMT

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

> >= DateAdd("d", -15, Date)
>
[quoted text clipped - 9 lines]
>
> > ryan

Reply to this Message