2 Replies Latest reply: Nov 10, 2014 2:42 AM by Suresh Babu RSS

    calender

    Suresh Babu

      i need calender that to starting and end date selection

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

        • Re: calender
          Anand Chouhan

          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