Need to get future expiry date in reports

[Gopi Krishna1]

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.

[Mohith Devatte]

Hello @Gopi Krishna1 ,

i think its because of the group by , it is not showing the records.

There is an article which says it wont group by records where future date is present .

Best way is to group by other field and then run the query which would give you the data.

Please remove group by on warranty field and try that .It will give you the data

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0719760

Mark my answer correct if this helps you 

Thanks

[Gopi Krishna1]

Any other way to get my requirement?

Please help me here.

[Mohith Devatte]

@Gopi Krishna1 i think remove group by and put group by for other field and then keep the same condition,

This is the only way to get future data.

Accept the solution if this helps 

Thanks

[Gopi Krishna1]

But my requirement is to show my report as mentioned below,

So to get this I definitely need to use group by as Warranty Expired(Date type filed) 

[Mohith Devatte]

@Gopi Krishna1 No for future dates data it wont be possible to group by.Its an OOB limitation

Thanks