AnsweredAssumed Answered

Convert Timestamp to Date

Question asked by sfroemming on Jul 5, 2018
Latest reply on Jul 9, 2018 by brianbrinley

Hi,

 

I have a source destination which stores timestamps as characters and a destination which stores dates as yyyy-MM-dd'T'HH:mm:ssZZ.

 

I have created my own javascript formula to convert the timestamp to ISO date like below:

d = new Date(result * 1000)
iso = d.toISOString()

 

And then doing the below date conversion. I have tried many other date conversions as well but not picturing these here.

 

The error I'm getting is the below:

Failed processing original documents i0i in the Microsoft Dynamics CRM CONN connector: com.boomi.connector.api.ConnectorException: Error in converter, couldn't parse 2018-02-12T00:50:25-05:00

 

I know it is because of the 00 as hours (Date parsing for the Microsoft Dynamics CRM connector ) but I can't figured out what to do to make this work. 

Any suggestions?

Outcomes