Hi,

I use ROWS - OVER to always have 12 lines for each month every request.

BY MONTH AS MONTH_TXT ROWS JAN OVER FEB OVER MAR OVER APR OVER MAY OVER JUN OVER JUL OVER AUG OVER SEP OVER OCT OVER NOV OVER DEC

Now I have the months 'hardcoded', to convert back to integer for correct sorting in the end.

MONTH_DIG/A3 = DECODE MONTH_TXT (Jan '01' Feb '02' Mar '03' Apr '04' May '05' Jun '06' Jul '07' Aug '08' Sep '09' Oct '10' Nov '11' Dec '12' ELSE '');

This works fine, however there must be a way to convert using DATE functions, would anyone know how to and which function to use?

Thanks,
SWES

This message has been edited. Last edited by: <Emily McAllister>,

You could use HINPUT within HPART?

-SET &MONTHNM = 'MAY';
-SET &MONTHNO = HPART(HINPUT(11, '01 &MONTHNM.EVAL 2016', 8, 'HYYMDs'), 'MONTH', 'I2');

-? &MONTH

T

Thanks for your suggestion Tony. The only thing is that here you have to hardcode '01' and '2016' in the part:

'01 &MONTHNM.EVAL 2016'

Shouldn't be a problem as you're only after the month anyway. As every month will have a 1st in any year, you could just use '1' and any arbitrary year - they'll be discarded anyway!

T