04-04-2017 06:17 AM
I have an output column with just the text 'January' or 'February' etc.
I want to create another column adjacent that will be a date in the following format, '01JAN2017'.
My issue is that I always want the date to be the first of the month but for the current year.
January = '01Jan2017'
February = '01Feb2017'
04-04-2017 08:54 AM
It does work
input month $;
fin_col=new_col || strip(new_col1) || trim(new_col2);