Question
Date Format Incoorect In Schedule Excel sheet
While schedule the report and the report gets delivered to your mailbox. When you open the excel, the date time format is in US Date format instead of Australian format (DD/MM/YYYYY) .could you please suggest any one.
***Updated by moderator: Lochan to add Categories***
Hi Jaanapatin,
Can you have a look into the below link which has similar discussion and see if it helps.
https://collaborate.pega.com/question/datetime-format-scheduled-report-excel
I have tried to have scheduled reports send Excel reports with correct date formats configured for the column. Running the report in the portal is OK and export it from there also works as expected but the scheduled report corrupts dates (US date format: first 12 days of amonth is converted to a month value, other values ar treated as texts).
Why is Pega the only application I ghave used having date issues? I have worked with quite some different systems but never had these issues as Pega have. I created my share of programs in Java/.NET to export data to Excel for programms all over the world. Nothing as whats happening in Pega. Please get this right once and for all. We are using Pega 7.2.2.
Hi Jaanapatin,
Have you checked below support article which resolved the similar issue?
https://community.pega.com/support/support-articles/date-time-format-incorrect
Thanks.