I have tried using the HName to pull the month from a date and have been unable to get it to work.

I am able to pull the month in Integer using DPART but they really want the Month in words rather than numbers.

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

please post the code that doesn't work. I have used 'HNAME' and it works.

MTH/A10=HNAME(today,'MONTH','A10')


Error:
Invalid Type Of Argument #1 for user Function HName

What's the format of today field?

HNAME requires the date to be date-time format.

TABLE FILE CAR
PRINT
COUNTRY NOPRINT
COMPUTE HTODAY/HYYMD = HDTTM('&YYMD', 8, 'HYYMD');
COMPUTE MTH/A10=HNAME(HTODAY,'MONTH','A10');
WHERE RECORDLIMIT EQ 1
END

If you're brave, you can try it in one statement:

TABLE FILE CAR
PRINT
COUNTRY NOPRINT

COMPUTE MTH/A10=HNAME( HDTTM('&YYMD', 8, 'HYYMD'), 'MONTH', 'A10');

WHERE RECORDLIMIT EQ 1
END

Why bother converting it at all? There is a data type for the month name. Mtr

 TABLE FILE YOUR_TABE
SUM YOUR_DATE/Mtr
BY YOUR_DATE
END
  

You can also use the FPRINT function to convert it to alpha if needed, but if you just want to display it, I wouldn't bother converting it from a smart date.