Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Excel is not considering my date value as date even after I tried many formatting? Need suggestion

Accepted answer
26
Views
2
Comments
User_90781
User_90781 Rank 1 - Community Starter
in Oracle Analytics Publisher

I am creating a XML publisher report where the date in the excel output should be in 'MM/DD/YYYY' format. Here I am able to achieve this format in excel however my excel is not considering it as a date eventhough the column format is date.

The problem is eventhough the date is in the expected format, I could see while using filter it looks like it is taking this as a string not as a date. Please refer the attached screenshot for reference.

Date_filtering.jpg
Date_filtering2.jpg

Tagged:

Best Answer

  • Nehemias-Oracle
    Nehemias-Oracle Rank 4 - Community Specialist
    Answer ✓

    Hello @User_90781

    I am not sure what version of BIP are you on but please see the below doc. Maybe this will help.

    Excel Outp Date Format Display Does Not Pick Up Formatting From RTF Template (Doc ID 2089844.1)

Answers