Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
5 subscribers
Views
3538 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
I'm using the Download DataSubset (on-premise) plugin in order to export dat
lesliem
over 9 years ago
I'm using the Download DataSubset (on-premise) plugin in order to export data to excel. I am using the JSON strings to pass multiple input parameters to the export rule. I am passing 2 DateTime paramters and a Text parameter. My input parameter is a type Text and I use the todatetime function to convert the 2 DateTime parameters from string to date within the export rule. If I use a range of 03/12/2015 12:00 pm - 03/19/2015 12:00pm in the report I get 41 records dates from 03/12/2015 12:30 pm - 03/19/2015 6:40am. But when I export them to excel using the rule I get 37 records. The datetime from the CDT are in GMT time but the input start and end dates are local Has anyone else used this plugin and had this issue? How do I convert the datetime to local time on the export?
Here is the call to the export rule:
local!ruleURI3: getdatasubsetdownloadlinkfromrule(rule: rule!ruleURI3, input: a!toJson({receivedDateTimeStart: tostring(local!receivedDateTimeS...
OriginalPostID-143326
OriginalPostID-143326
Discussion posts and replies are publicly visible
Parents
0
lesliem
over 9 years ago
If I convert my start and end datetime parameters to GMT before sending them to the plugin my results will be different than the results of the report which are using MDT. I will be getting records for received dates 6 hours ahead of MDT.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
lesliem
over 9 years ago
If I convert my start and end datetime parameters to GMT before sending them to the plugin my results will be different than the results of the report which are using MDT. I will be getting records for received dates 6 hours ahead of MDT.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data