Focal Point
Separate data by Month

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7761018331

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
GCohen
If 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