Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need calender that to starting and end date selection
how can i use it.......
Hi,
Try like
Let vMinDate = NUM(Date#('08/12/2005','DD/MM/YYYY'));
Let vMaxDate = NUM(Date#('30/06/2006','DD/MM/YYYY'));
TempDateTable:
LOAD
date($(vMinDate)+IterNo()-1) AS TempDate
AutoGenerate 1
WHILE $(vMinDate)+IterNo()-1<= $(vMaxDate);
MasterCalendar:
LOAD
TempDate,
Month(Floor(TempDatefield)) AS Floordate,
Year(date(TempDatefield)) as Year,
Month(date(TempDatefield)) as Month,
Day(date(TempDatefield)) as Day,
Time(date(TempDatefield)) as Time,
Week(date(TempDatefield)) as Week
Resident TempDateTable;
Regards
Anand
i wiil try