Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

Any other way like to get via Performance Analytics?

@Gopi Krishna1 you can try it by creating an automated indicator and then a break down which can on warranty field .But i think it wont give any data but you can give it a shot !