topic Re: Date Conversion Issue in Talend Studio

Date Conversion Issue

Anonymous — Tue, 12 Mar 2019 10:56:43 GMT

Hi,

I have an Excel sheet with a date column in the format below

Date

41575

31576

42578

34423

I want to convert it into the following format.

Date

2013-10-28

1986-06-13

2016-07-27

1994-03-30

Please help me.

vapukov — Tue, 12 Mar 2019 12:30:36 GMT

Hi,

if read column as integer, and use in tMap

TalendDate.addDate(TalendDate.parseDate("yyyy-MM-dd","1900-01-01"),row1.date_add - 2,"dd")

result will be as expected:

|date      |
|=--------=|
|2013-10-28|
|1986-06-13|
|2016-07-27|
|1994-03-30|
'----------'

Anonymous — Wed, 13 Mar 2019 04:38:48 GMT

Many thanks, the issue has been resolved.