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

Date Display as "Date Format" but not "Text Format" in Excel output

Received Response
22
Views
1
Comments
User_MP41P
User_MP41P Rank 2 - Community Beginner
in Oracle Analytics Publisher

Hello there,

The report has assigned the "requested date" as "DD/MM/YY" format while it is showing as "Text" in excel output. Is there a way to change it as Date format in Excel ?

Thanks,

Jason

image.png

image.png

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics & AI Lead

    If your output is a simple table, I would suggest an Excel layout.

    Otherwise you have to format the column(s) as date after it is generated.

    Rgds,

    Kevin