How to calculate a period of time

  • Thread starter Thread starter AmandaP
  • Start date Start date
A

AmandaP

Hi, I really need some help on this one, I cannot seem to
be able to get it right.

I have this query which returns dates when an inspection
is due called [InspectionDue]. I have put this criteria
beneath it: >=Date()+30. The only problem is that it
returns all dates after today's date and all I really want
is any date equal or after today's date within the next 30
days, not beyond the 30 days limit. Is there a way to do
this right?

Please help.
Thanks,
 
Thanks Roger,

It worked!
Brilliant.
-----Original Message-----
BETWEEN Date() AND Date()+30

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Hi, I really need some help on this one, I cannot seem to
be able to get it right.

I have this query which returns dates when an inspection
is due called [InspectionDue]. I have put this criteria
beneath it: >=Date()+30. The only problem is that it
returns all dates after today's date and all I really want
is any date equal or after today's date within the next 30
days, not beyond the 30 days limit. Is there a way to do
this right?

Please help.
Thanks,
Click to expand...


.
Click to expand...
 
Back
Top