Report 30 days from Expiration Date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 04:40 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 05:10 PM - edited 07-17-2024 05:48 PM
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..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 05:38 PM
Yes. In the report you can create a filter using 'relative' operator
Ex.
Please mark this response as correct or helpful if it assisted you with your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 10:21 PM
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
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/