Expiration Date, display only if date is 30 days from now

[siberianfox]

I'm trying to build a Query that looks at expiration dates, but only displays them if the date is equal to, or less than, 30 days from the current date.

The structure:

PTAC is the name of the field in which the user enters the start date.

Expr1 is the name of a calculated expiration date, which is one year from PTAC.

Now if there are 50 records, I only want the query to display those which expire within 30 days. If anyone has any idea how this can be done, I would really appreciate the help. Thanks

 

[pbaldy]

How about a criteria of

Between Date() And DateAdd("d", 30, Date())

 

[ckchappell]

Thank you! I came here looking for the exact same thing. Works like a charm.

 

[pbaldy]

Glad it worked for you!

 

[siberianfox]

Wonderful, it works perfectly. Thank you very much!