Hi, Am using export to excel plugin - getdatasubsetdownloadlinkfromru

madhubindug over 8 years ago

Hi,

Am using export to excel plugin - getdatasubsetdownloadlinkfromrule to export report data into excel. I am facing issue with incorrect date time stamp after exporting the data into excel. For ex: In report UI it is 10/31/2015 5:53 AM PDT and after exporting it is 10/31/2015 12:53:48 PM in the excel sheet. PFA attached snap of the report. Any suggestions to resolve this issue.
Thanks,
Madhu

Issue Snap Shot.docx

Discussion posts and replies are publicly visible

Parents

0 madhubindug over 8 years ago

Yes, am using ExportableDataSubset plugin and below is the code i have modified using local(), its giving 500 internal server error:
c2:apply(rule!BWIS_WF_REP_convertToLocal,local!datasubsetNew.data.c2)
convertToLocal code - if(or(isnull(ri!dateInput),ri!dateInput=""),ri!dateInput
local(ri!dateInput,"PDT"))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 madhubindug over 8 years ago

Yes, am using ExportableDataSubset plugin and below is the code i have modified using local(), its giving 500 internal server error:
c2:apply(rule!BWIS_WF_REP_convertToLocal,local!datasubsetNew.data.c2)
convertToLocal code - if(or(isnull(ri!dateInput),ri!dateInput=""),ri!dateInput
local(ri!dateInput,"PDT"))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data