Hi, Am using export to excel plugin - getdatasubsetdownloadlinkfromru

madhubindug over 9 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 Tom Ryan
Appian Employee
over 9 years ago

I think you can get around this behavior by using the local() function

forum.appian.com/.../Date_and_Time_Functions.html

You would need to change the report column definition to local( XXX ) where XXX is the current value. Then you should see the datetime exported in the local timezone.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tom Ryan
Appian Employee
over 9 years ago

I think you can get around this behavior by using the local() function

forum.appian.com/.../Date_and_Time_Functions.html

You would need to change the report column definition to local( XXX ) where XXX is the current value. Then you should see the datetime exported in the local timezone.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data