I am having a strange problem. My source is a Excel file which has a date field. I read the date field as string as it in 1-Jan-2017 format. Using tMap I convert it into Date and change it to 01-01-2016. Now when I again convert it back to string using tConvertType the month changes to 00. So irrespective of the date the month is defaulted to 00.
How do I overcome this issue ?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema