Report Date Format Issue for Excel when exported from Unifier

User_PLBK4

Excel does not recognize the exported date format and manual adjustment is needed for the date to be recognized in a filter.

Is it possible for us to change the date format of the export to the below format? We are facing issues when we are trying to sort the columns and filter them. A manual process is needed but when we are working with multiple files and customers this becomes a higher priority need when used daily.

Current - Import Data Format (Screenshot below RIGHT SIDE)

25-Jun-2024

Format we want the Import to come in as (Screenshot below LEFT SIDE)

2024-02-8

This allows us to filter based on Year > Month > Date (Screenshot LEFT SIDE)

Workaround solution suggested:

"Formatting Dates

https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#GUID-2E9599CF-7066-4181-940F-F03C09DD37B5

Excel seems to have issues recognizing date values. If you use a function such as REPLACE in the formula field that references the data element, this will help format the dates.

"

TestUser35

Hi @User_PLBK4 were you able to get the expected output without adding any extra columns? I'm facing the same issue as well.

User_PLBK4

We still face the same issue, we have to modify the excel sheet for this to work. Oracle output still does not allow date to be recognized automatically. Oracle suggested to upvote this issue for it to be added as a more urgent enhancement.

TestUser35

Thanks for the suggestion; we'll upvote it.