AnsweredAssumed Answered

Test execution of Case to MySql for Unicloud Production completed with errors. Embedded message: [Function: Date Format]: DateFormat cannot parse '20170109 052700.000': java.text.ParseException: Format.parseObject(String) failed

Question asked by zesler on Jul 31, 2018
Latest reply on Aug 1, 2018 by naresh.kallali@kpit.com

Hello All;

  I've been beating my head against this for a while now.  I'm extracting data from netsuite, and writing it to Mysql.  in this specific case,  I need to take a date/time from Netsuite in UTC, and convert it to GMT, but i keep getting

 

Test execution of Case to MySql for Unicloud Production completed with errors. Embedded message: [Function: Date Format]: DateFormat cannot parse '20170109 052700.000': java.text.ParseException: Format.parseObject(String) failed

 

Both fields are set to date/time.   I don't understand why it's showing a format different than what the source document displays..

From the document viewer, source data is

 

<
searchValue
>
2017-01-09T05:27:00.000-05:00
</
searchValue
>
input and output masks
thanks
Zach

Outcomes