Question
GENPACT
IN
Last activity: 18 Sep 2017 7:11 EDT
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***
Pegasystems Inc.
IN
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
Pegasystems Inc.
IN
Hello,
Are you making use of the column formatting option at the report level ? Do not check Ignore formatting when exporting to excel in the Data Access Tab.
Bernving
NL
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.
Pegasystems Inc.
IN
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.
Bernving
NL
Read the article and see it is symptom treatment instead of a generic solution. For every TZ or local settign I need to use UpdateLocaleSettings in pyExecuteTask to get things right