Date format issue in BI Excel Output
Hi Team,
I am working on BI publisher with excel output for PA to OTL Reconciliation.
For this report II have to provide 2 input parameter Start_date, End_date.
I am taking above values from PA_PERIODS_ALL (start_date, end_date) through value set.
Both the dates should be print in excel output also.
From the LOV I am selecting Start_Date as 01-JAN-2004 but in report output I am getting as like this '2004-01-01T00:00:00.000+00:00', same way for end_date too.
Please help me how to achieve to print the date as 01-JAN-2004.
Report output:
Thanks,