AnsweredAssumed Answered

Cannot declare a Process Property of type DateTime

Question asked by MohammadRamezan5551 on Nov 2, 2014
Latest reply on Jan 18, 2015 by Adam Arrowsmith
I' wondering if anyone have ever come across this issue before and been able to resolve it. Basically I need to setup a persisted process property of type DateTime for my process. This property is used for a Salesforce connector to pass a parameter value for a field of type Timestamp (i.e. "LastModifiedDate").

The closest available types are Date, String, or Number, but all of those give me the error that is due to using an incorrect type. Saleforce SOQL query expects a DateTime value with timezone for this field without any quotes (an example is 2014-10-30T23:59:59-08:00 or 2014-10-31T07:59:59.999Z with no single quotes).

If I had an option, before passing the value to the Salesforce operation parameter, I could create a user defined function to receive the String type process property and return the DateTime type with format that is acceptable by Salesforce, however unfortunately the platform doesn't provide me with an option to create a function.

Any advice or suggestion is appreciated.

Outcomes