calender

sakamsureshbabu — Mon, 10 Nov 2014 07:16:27 GMT

i need calender that to starting and end date selection

how can i use it.......

Re: calender

its_anandrjs — Mon, 10 Nov 2014 07:35:41 GMT

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

sakamsureshbabu — Mon, 10 Nov 2014 07:42:11 GMT

i wiil try