Date Conversion Issue

[Anonymous]

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 · Accepted solution]

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]

Hi @vapukov 

Many thanks, the issue has been resolved.