Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThat was a cleansing experience.
This one was straightfoward.
I used this to derive the month value: (there is preceding code)
IF [Current_Month] = 'JAN' THEN '01' ELSEIF [Current_Month] = 'FEB' THEN '02' ELSEIF [Current_Month] = 'MAR' THEN '03' ELSEIF [Current_Month] = 'APR' THEN '04' ELSEIF [Current_Month] = 'MAY' THEN '05' ELSEIF [Current_Month] = 'JUN' THEN '06' ELSEIF [Current_Month] = 'JUL' THEN '07' ELSEIF [Current_Month] = 'AUG' THEN '08' ELSEIF [Current_Month] = 'SEP' THEN '09' ELSEIF [Current_Month] = 'OCT' THEN '10' ELSEIF [Current_Month] = 'NOV' THEN '11' ELSEIF [Current_Month] = 'DEC' THEN '12' ELSE '12' ENDIF