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!
In sys_properties.list, look for a glide.sys.date_format... I was able to manipulate the way it exported through that.
Initial export:
Changing property:
After change:
There is no property that I'm aware of. You can format them in excel though. Select your column and press ctrl + 1. Then go to the date category and pick your desired date format.
You can also pick the custom category and create your own format.
Regards,
Tony Shabani
In sys_properties.list, look for a glide.sys.date_format... I was able to manipulate the way it exported through that.
Initial export:
Changing property:
After change:
