Compare date/time fields in a report

ceraulo · ‎04-20-2022

Hello!

I have a table with 2 date/time fields (DTField1, DTField2). I want to create a report that shows all records where DTField1 is older than DTField2.

Is this possible?

Please help!

Thank you.

Voona Rohila · ‎04-20-2022

Hi ceraulo

Yes, try 'is more than' or 'is less than' operator in filter.

sample:

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

Ankur Bawiskar · ‎04-20-2022

Hi,

So what condition did you add?

Can you share screenshot

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Aman Kumar S · ‎04-20-2022

Try this:

Best Regards
Aman Kumar