Need to get future expiry date in reports

Gopi Krishna1
Tera Contributor

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.

11 REPLIES 11

Mohith Devatte
Tera Sage
Tera Sage

Hello @Gopi Krishna1 ,

You can try with after filters available in condition builder.

Example: Warranty date after one week.

Screenshot 2023-08-21 at 12.15.11.png

 

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

Hi @Mohith Devatte ,

Thanks for quick response.

I have tried this condition but I am getting no display data.

GopiKrishna1_0-1692600843929.png

 

And I need to pull my future expired records as shown below,

GopiKrishna1_1-1692601050917.png

 

 

@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.

@Mohith Devatte yes this query is satisfying in list view of the table