View Full Version : Last 45 days...


travismp
08-25-2006, 10:03 AM
I have a Date field [TESTDATE]

I would like a query that shows the last 45 worth of data entered into the system. How would I do this? Thanks.

Travis

raskew
08-25-2006, 10:35 AM
Hi -

In TestDate's criteria cell:

>= date()-45

HTH - Bob

travismp
08-25-2006, 12:01 PM
That worked perfect. Thank you very much kind sir.