AnsweredAssumed Answered

Date format error from mapping function

Question asked by cristi936523 on Feb 10, 2018
Latest reply on Mar 22, 2018 by leif_jacobsen

I have a requirement to map some BankToCustomer Statements to Netsuite. The input format for the date is like: 2017-12-19T10:33:37+01:00, and the expected output format is like: yyyyMMdd HHmmss.SSS. My process fails with the error:


[Function: date_today_if_null, Scripting (Step 2)]: Error parsing DATETIME input value '2017-12-19T10:33:37+01:00' for parameter date2.; Caused by: Unparseable date: "2017-12-19T10:33:37+01:00"


I have tried to convert it inside a map function using the input mask: yyyy-MM-dd'T'HH:mm:ssZZ

and the output mask: yyyyMMdd HHmmss.SSS but this error keeps popping up. I would appreciate some help, as I can see the format here: Date/Time datatype but it does not seem to work.