Need to get future expiry date in reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2023 11:42 PM
Hi All,
I have requirement to get future date by using group by in reports Bar type.
For example a record having customized field called Warranty expiry(Date field) which is holding expiration date of respective record. So using reports (Bar type) and group by warranty expiry I need to get future expired records as of now I am able to fetch past/expired records.
For example one record expired date is 10-08-2023 and another is 31-08-2023. I am able to fetch expired record(10-08-2023) as expired more than 1 week before. Like wise I need to fetch 31-08-2023 as expiring in next week like that.
Please help me here.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2023 11:46 PM
Hello @Gopi Krishna1 ,
You can try with after filters available in condition builder.
Example: Warranty date after one week.
I just took actual end date as example in the above screenshot.
Hope you can do the same thing for your warranty field.
Mark my answer correct if this helps you
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2023 11:58 PM
Hi @Mohith Devatte ,
Thanks for quick response.
I have tried this condition but I am getting no display data.
And I need to pull my future expired records as shown below,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2023 12:05 AM
@Gopi Krishna1 can you run the same query in the list view of the table and see if there are any records satisfying the conditon.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2023 12:27 AM
@Mohith Devatte yes this query is satisfying in list view of the table