System Property[glide.sys.time_format]

MakotoHorioka
Tera Guru

Hello, team.

 

We changed the System Property [glide.sys.time_format] setting from hh:mm:ss to hh:mm:00.

Then, when exporting from a table in Excel, the date was no longer output correctly.

If you know a solution, please let me know.
thank you.

 

MakotoHorioka_0-1698391414377.png

 

2 REPLIES 2

Martin Ivanov
Giga Sage
Giga Sage

My assumption is that the issure is in your execl settings, rather than in servicenow. Try to go to cell E2, then go to formatting - select time:

MartinIvanov_0-1698397639572.png

 


Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Martin Ivanov
ServiceNow MVP 2023, 2024

@Martin Ivanov 
Thank you for answering.
I have confirmed that the correct date is displayed in the Excel settings.
Before changing the settings, I was able to output the correct values.
Is there no solution on the ServicNow side?