Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Compare date/time fields in a report

ceraulo
Mega Guru

‎04-20-2022 12:05 AM

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.

0 Helpfuls
  • 1,789 Views
3 REPLIES 3

Voona Rohila
Tera Patron

‎04-20-2022 12:18 AM

Hi ceraulo

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

sample:

find_real_file.png

 


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
5x ServiceNow MVP
Preview file
18 KB
0 Helpfuls

Ankur Bawiskar
Tera Patron

‎04-20-2022 12:27 AM

Hi,

So what condition did you add?

Can you share screenshot

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Aman Kumar S
Kilo Patron

‎04-20-2022 02:19 AM

Try this:

find_real_file.png

Best Regards
Aman Kumar
Preview file
7 KB
0 Helpfuls