I need to extract from my calendar the last sunday of the month
how can i do this?
May similar to this?
LOAD Date(makedate(2013)+recno()) as TempDate
LOAD *, weekday(LastSunday) as Test;
LOAD Date(max(if(weekday(TempDate)=6,TempDate))) as LastSunday
group by monthstart(TempDate);
Retrieving data ...