Date Range Query for Valid Period

[Ari C]

I have a field that is a date and I need a criteria expression so that the query only returns dates that are no more than 1 year in the future.



Here is the scenario:
A release of information (ROI) is good for 1 year. The database has a field for the date the ROI was signed. We have been collecting data since 2012. When I run the query I would like to only have data that is inside that 1 year valid period. So if I run the report today (11/18/2014) I should only get back records that are between 11/18/2013 and 11/18/2014 inclusive.

If you need more information please let me know.. I am having a bit of trouble figuring out how to explain this further.

Thank you for your time and consideration

[pbaldy]

Check out the DateAdd() function. Your example is the opposite of your description, but generally a criteria like:

Between Date() and DateAdd(...)

[Ari C]

Thanks for the quick response. I just re-read what I wrote and you are correct that my items are opposite. The scenario is what I need. I will try what you recommend.

[Ari C]

This worked... thank you so much

[pbaldy]

Happy to help!