I need help in building a date out of string field.
I have a varchar field of CALMONTH which comprises of values like '201604', '201512' i.e. combination of year and month.
I need to create a new CALDATE column in query transform(date datatype), whose mapping should contain the logic to get a date from CALMONTH field. CALDATE should contain value like '2016.04.01', '2015.12.01' (YYYY.MM.DD)
I need to make day as '01' always.
Please give me logic to handle this. Thanks in advance.