Home Discussions Questions & Answers Customizing the Display Format of Dates in Excel

Customizing the Display Format of Dates in Excel

Avatar photoCustomer July 7, 2020 at 7:31 am

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support July 8, 2020 at 7:28 am  

      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.

    • Avatar photoCustomer July 10, 2020 at 2:02 am  

      If I leave this profile unset, what format is used?

    • Support July 10, 2020 at 5:52 am  

      If it is not set, the value from the standard Oracle profile ‘ICX: Date format mask’ is used.

    • Avatar photoCustomer July 12, 2020 at 7:00 am  

      If I need to force a long date format (full year and leading zero for day), is that a separate profile?

    • Support July 12, 2020 at 10:06 am  

      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.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: