December 03, 2004, 07:48 PM
<MikeBres>Separate data by Month
Hello, I'm trying to figure out how to display my data by months. The date I am using is a smart date. I'm using the mainframe version of FOCUS v7.03. If I understand correctly this is before HPART was available.
So is there someway I can label and separate by data by month?
Thanks
Mike
December 03, 2004, 08:05 PM
GCohenIf you have a data field which is a smart date (FIELD=MDATE), ie has a format like YYMD then you can pull the month out with a Define as.
DEFINE FILE ...
MONTH/M = MDATE ;
END
But you should have a test on YEAR else you will get the month data for all years.
December 03, 2004, 08:17 PM
<MikeBres>Thank you. It works great.
The year isn't an issue as the data is only the current quarter. However, I will keep that in mind.
Thanks
Mike