Customizing the Display Format of Dates in Excel

How can I set a custom date format mask specifically for the dates displayed in Blitz Report XLSX output files, independent of other Oracle profiles?

5 replies

Support Enginatics July 8, 2020
You set the profile option ‘Blitz Report XLSX Date Format’. This allows you to define the date format mask for Blitz Report XLSX output files.
Customer July 10, 2020
If I leave this profile unset, what format is used?
Support Enginatics July 10, 2020
If it is not set, the value from the standard Oracle profile ‘ICX: Date format mask’ is used.
Customer July 12, 2020
If I need to force a long date format (full year and leading zero for day), is that a separate profile?
Support Enginatics July 12, 2020
Yes, you can enable the profile option ‘Blitz Report XLSX Use Long Date Format’ to show leading zeroes for the day and the full year.