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

Question

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

Kevin M-Oracle · Answer

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