First of all you need a calendar in your data:
TempCalendar:
LOAD
$(vMinDate)+ITERNO()-1 AS NUM,
DATE($(vMinDate)+ITERNO()-1,'D-M-YYYY') AS TempDate
AUTOGENERATE (1) WHILE
$(vMinDate)+ITERNO()-1 <= $(vMaxDate);
TRACE . . . Kalender - START LOAD Calendar;
Calendar:
LOAD *
,autonumber(Date) AS %Key
;
LOAD TempDate AS Date
,YEAR(TempDate) AS Year
,'Q' & Ceil(Month(TempDate)/3) AS Quarter
,MONTH(TempDate) AS Month
,WEEK(TempDate) AS Week
,WEEKDAY(TempDate) AS WeekDay
,DAY(TempDate) AS Day
,DATE(MONTHSTART(TempDate), 'MMM-YYYY') AS MonthYear
,if (Week(TempDate)=1 and Month(TempDate)=12,Week(TempDate)&'-'&(Year(TempDate)+1), if (Week(TempDate)>=52 and Month(TempDate)=1,Week(TempDate)&'-'&(Year(TempDate)-1),Week(TempDate)&'-'&Year(TempDate))) as WeekYear
RESIDENT
TempCalendar
ORDER BY
TempDate;
DROP TABLE TempCalendar;
After this you can put some multiple or single dropdown boxes on your screen containing these selections.
E.G. year / month / week / day ... or the complete date
You could also take a datetime picker on the Date field ...
rgrds Anita
