Help with displaying dates in a report, that will expire in 30-days

[corbitt]

I'm creating a report, using the report wizard, that will display all credit cards due to expire in 30-days. My field name is "expdate". It contains expiration dates in the Short Date format xx/xx/xx.

Your help is appreciated.

Thanks,

Jeremy

 

[curtterp]

Are you using a query behind the report? If so, use the criteria of &quot; <=Now()+ 30 &quot; . That will show you all the hits that fall before the next 30 days. I use the same criteria for a bill tracker that we use at my home for bills due only in the next week, next pay period, and the next month. It works well for me.

have fun ;-)