As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I need to list the year in month order, not alphabetical order. Here is what I have but it does not order correctly. Any suggestions?
DEFINE FILE METRIC_DATA_HOURS MO/A12=DECODE MONTH (January January February February March March April April May May June June July July August August September September October October November November December December ); END TABLE FILE METRIC_DATA_HOURS PRINT DST.MO BY MO ON TABLE PCHOLD FORMAT XML END
Thanks, DeniseThis message has been edited. Last edited by: DMA,
WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
Posts: 57 | Location: NYC | Registered: November 13, 2008