Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

duration in pivot report is showing in (1970-01-01)

Community Alums
Not applicable

I created a pivot format report to show duration of RITM in each state.  It shows the duration along with (1970-01-01) format. ow to fix it?

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@Community Alums 

that's OOTB behavior for Duration type field.

If my response helped please mark it correct and close the thread so that it benefits future readers.

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