TalendDate.parseDate giving unexpected output

ftobias1677780896 — Wed, 08 Mar 2023 14:48:07 GMT

Hello, I am using TalendDate.parseDate in tMap but I am getting unexpected results.

I am processing many files, all the same format, but some files are not returning a correct date. Please see below:

tMap
- expression "TalendDate.parseDate("yyyyMMdd",StringHandling.LEFT(row4.start,8)) "
- Date pattern "MM-dd-yyyy"
Data in file
- start
  ="
  20230213 00:23:11
  "
output
- 02-44-2023

All my files have the same field and same beginning format. I am not sure if this is a Talend bug or corrupt data

Any ideas are welcomed!

Thanks

Re: TalendDate.parseDate giving unexpected output

Anonymous — Thu, 09 Mar 2023 00:47:15 GMT

For debugging, print the value of StringHandling.LEFT(row4.start,8), to check if it returns the expected string before it is parsed to a Date.

Regards

Shong