TimeZone difference in getdatasubsetdownloadlinkfromprocess

arushit1 over 7 years ago

I am using getdatasubsetdownloadlinkfromprocess function to export the datasubset created using a!queryProcessAnalytics to excel. In that datasubset/portal report, I have a datetime field with values in PST time zone when displayed in interface designer and tempo suite. However while trying to export the same data to excel the same data is getting changed to GMT.
Is there any way to export the values in datetime field to excel in the same way it is displayed in tempo suite.Please advise

Discussion posts and replies are publicly visible

0 helmuta over 7 years ago

Here is one way that we have use it
gmt(datetime(2011, 2, 07, 16, 05),"America/New_York") returns 2/7/2011 4:05 PM
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel