I'm using the Download DataSubset (on-premise) plugin in order to export dat

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
  • ...tart), receivedDateTimeEnd: tostring(local!receivedDateTimeEnd), filter: local!PMNameFilter})),

    Here is the export rule:
    =with(
    local!search: a!fromJson(ri!input),
    'type!{urn:appian:plugin:datasubsetdownload:types}ExportableDataSubset'(
    filename: "CA Event by Est. Proc. Date BLANK_"&now(),
    fieldNames: {
    "caEventId",
    "securityId",
    "ticker",
    "electionTypeDescription",
    "actionTypeDescription",
    "subActionTypeDescription",
    "estimatedProcessingDate",
    "receivedDate",
    "expirationDate",
    "exDate",
    "effectiveDate",
    "currentStatus"
    },
    fieldLabels: {
    "Event ID",
    "Security ID",
    "Ticker",
    "Election Type",
    "Action Type",
    "Sub Action Type",
    "Est. Processing",
    "Rec'd Date & Time",
    "Expiration",
    "Ex Date",
    "Effective",
    "Current Status"
    },
               datasub...
Reply
  • ...tart), receivedDateTimeEnd: tostring(local!receivedDateTimeEnd), filter: local!PMNameFilter})),

    Here is the export rule:
    =with(
    local!search: a!fromJson(ri!input),
    'type!{urn:appian:plugin:datasubsetdownload:types}ExportableDataSubset'(
    filename: "CA Event by Est. Proc. Date BLANK_"&now(),
    fieldNames: {
    "caEventId",
    "securityId",
    "ticker",
    "electionTypeDescription",
    "actionTypeDescription",
    "subActionTypeDescription",
    "estimatedProcessingDate",
    "receivedDate",
    "expirationDate",
    "exDate",
    "effectiveDate",
    "currentStatus"
    },
    fieldLabels: {
    "Event ID",
    "Security ID",
    "Ticker",
    "Election Type",
    "Action Type",
    "Sub Action Type",
    "Est. Processing",
    "Rec'd Date & Time",
    "Expiration",
    "Ex Date",
    "Effective",
    "Current Status"
    },
               datasub...
Children
No Data