Customize display value for exported Date/Time data into Excel

[karenwoo]

Hey!

We have recently upgraded from Eureka Patch 11 to Fuji Patch 6 and have noticed a change in the format of the data that is exported into excel. I was able to find the following from the wiki "Date, Date-Time, and Time fields are all exported as their display values, displayed using a custom format instead of the system date format.".

So my question is, is the display value that is exported customizable? Is there a way to change the format back to the how it was before we upgraded to Fuji?

Previously date/time fields would export in the following format 'yyyy/mm/dd hh:mm:ss'.

Currently date/time fields export in the following format 'mm-dd-yyyy hh:mm:ss a'.

Thank you in advanced!

[santhoshaitha]

Hello Mike,

We do face the same issue but we do not want to change the system property 'glide.sys.date_format' as this will also change the way the date is displayed in ServiceNow UI.

We use the custom date format as 'yyww.d' as the system date format. So when I export the list to Excel, I get the date format as eg: '16ww.5 09:05:56' instead of the default format 'mm/dd/yyyy hh:mm:ss'. In excel it still shows 'ww' instead of the actual week number.

In Eureka it used to export in the default format 'mm/dd/yyyy hh:mm:ss' irrespective for date format set by the system property. But starting from Fuji, the date format exported is the displayed format.

So how do I make the date format to default format in excel export instead of the displayed format?

Thanks in advance!

Regards,
Santhosh