Skip to Content
May 19, 2016 at 06:46 PM

How to calculate full Date from Year.Month String


Hi Experts,

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.