Report 30 days from Expiration Date

[HenryD]

Hello, right now we have a custom field that stores a "Expiration Date" that the user submits for a form. is there anyway to get a report to show when that expiration date gets within 30 days it will expire. 

[AnirudhKumar]

Scheduled jobs to the rescue!

Have one the runs every day at midnight. The script needs to perform a query of the records, then for each record perform a date difference, and return the record if the difference is equal to 30.

Edit: My bad! Sanjiv's solution is better..

[SanjivMeher]

Yes. In the report you can create a filter using 'relative' operator

Ex.

[AndersBGS]

Hi @HenryD ,

The relative operator in the report designer will help you out with your question:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders