Master Calendar Data

    Hi All,

    Below script helps in generating the Master calendar. 

     

    Hope this will help you.

    LET vDateMin=num(makedate(2014,01,01));

    LET vDateMax=floor(monthend(today()));

    LET vDateToday = num(today());

     

     

    Calender:

    LOAD Distinct Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS Date,

    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);

     

     

    Capture.PNG