I have 2 dates in the same table that I want to link to my calendar, can I do this? I have a leavers table and I have start date and leave date. In the front end I would like to able to select a date and see how many people left on this date as well as started
Do I need to change my calendar?
LET vDateMin=num(makedate(2011,01,01));
LET vDateMax=floor(monthend(today()));
LET vDateToday = num(today());
Calender:
LOAD Distinct Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS Date,
Day(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Day,
month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Month,
year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Year,
monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Monthname,
Week(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Week
AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);
