Dates showing as #################### in Excel Export

abweiss4 · ‎08-21-2024

Has anyone encountered an issue (and how to resolve) where open/close/updated dates from cases are showing as #################### in an Excel export rather than as the date and time?

Dr Atul G- LNG · ‎08-21-2024

Hi @abweiss4

It depends on your excel cell length or I will say format.

Just expand the cell n you can see the date.

In SN we store date n time together, so it did not fit when we Export and show #

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

Dr Atul G- LNG · ‎08-22-2024

No issue mate. Excel cell has some default length, you may change that.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************