for i =0 to 660
load Date(today()-$(i)) as dateField
month(MonthYear) as Month,
year(MonthYear) as Year;
if(day(dateField)>25,MonthStart(addmonths(dateField,1)),MonthStart(dateField)) as MonthYear
drop Table DateList;
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.