Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to extract from my calendar the last sunday of the month
how can i do this?
tnks!
May similar to this?
TempCalendar:
LOAD Date(makedate(2013)+recno()) as TempDate
AutoGenerate 500;
Calendar:
LOAD *, weekday(LastSunday) as Test;
LOAD Date(max(if(weekday(TempDate)=6,TempDate))) as LastSunday
Resident TempCalendar
group by monthstart(TempDate);
May similar to this?
TempCalendar:
LOAD Date(makedate(2013)+recno()) as TempDate
AutoGenerate 500;
Calendar:
LOAD *, weekday(LastSunday) as Test;
LOAD Date(max(if(weekday(TempDate)=6,TempDate))) as LastSunday
Resident TempCalendar
group by monthstart(TempDate);
Tnks Swuehl!!