I'm using the following line:

ACROSS STATUS_CHANGE_DATE_MODIFIED AS 'Month'

Giving me the below output:

Month
01-2019 02-2019 03-2019 12-2018

I'd like 12-2018 to be left most and then continue chronologically.

My STATUS_CHANGE_DATE_MODIFIED is determined using SQL like so:

to_char(stat.status_change_date, 'MM-YYYY') status_change_date_modified,

Any help would be greatly appreciated! Thanks!

This message has been edited. Last edited by: FP Mod Chuck,

It seems that STATUS_CHANGE_DATE_MODIFIED is not a date but a char due to : to_char(stat.status_change_date, 'MM-YYYY'), reason why 01-2019 is ordered before 12-2018
If it was a date 12-2018 was placed before 01-2019

You should better keep the date as a date and use IB format to have the date displayed as MM-YYYY

something such as

DEFINE FILE GGSALES
DATEMMYYYY /MYY = DATE;
END
TABLE FILE GGSALES
SUM DOLLARS
BY DATEMMYYYY
END

This message has been edited. Last edited by: MartinY,

Add another SQL column and use as your sort:
to_char(stat.status_change_date, 'YYYY-MM') status_change_date_sort

In your ACROSS:
ACROSS STATUS_CHANGE_DATE_SORT NOPRINT
ACROSS STATUS_CHANGE_DATE_MODIFIED AS 'Month'