Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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| '----------'
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| '----------'