Dates

[#1]

Hello,

I need to extract from my calendar the last sunday of the month

how can i do this?

tnks!

[swuehl · Accepted solution]

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);

[#3]

Tnks Swuehl!!