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.