topic Re: Date Issue in Talend Studio

Date Issue

Anonymous — Fri, 22 Jun 2018 07:01:16 GMT

I am getting date as 1/1/1800 from the input excel. Type is String. How to pass this value to destination Database.

I received an error that its "Unparseable date" Please suggest

Re: Date Issue

krengan21 — Fri, 22 Jun 2018 07:24:03 GMT

If 1/1/1800 is of the format M/d/yyyy then parse it as TalendDate.parseDate("M/d/yyyy",row1.date) in the target while parsing from the excel .Please make change in the parsedate function based on the format in the source.

Re: Date Issue

Anonymous — Fri, 22 Jun 2018 08:31:19 GMT

Hi Rengen,

I am already having this code for other proper date's from the input. Only 3 rows are having this 1/1/1800 (m/d/yyyy). Please suggest how to handle this now

("".equals(row1.Date) || row1.Date == null ? null : TalendDate.parseDateLocale("EEE MMM dd HH:mm:ss zzz yyyy",row1.Date,"EN"))

Re: Date Issue

krengan21 — Fri, 22 Jun 2018 11:41:32 GMT

hi @samisyed80

try giving if condition based on the date format inside tmap and check whether it is working or not

Re: Date Issue

Anonymous — Sat, 23 Jun 2018 09:46:52 GMT

Thanks rengan its resolved

Re: Date Issue

krengan21 — Sat, 23 Jun 2018 12:11:42 GMT

Thanks for the update