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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables