Master Calendar with every 30 Minutes

    Hi All,

     

    Please find below script for generating the Master Calendar with every 30 minutes

     

    LET vMinDate = Num(MakeDate(2014,1,1));  // Calendar Start Date

    LET vMaxDate = Num(Today()); // Calendar End Date

    LET vDays = vMaxDate - vMinDate + 2;  // Calculating number of days between Start & End Dates

     

    Calendar:

    LOAD Date(Floor(TimeStamp)) AS Date,

    TimeStamp,

    Hour(TimeStamp) AS Hour,

    Minute(TimeStamp) AS Minute;

    LOAD

        Timestamp($(vMinDate) + (RecNo() - 1)/48) as TimeStamp

    AUTOGENERATE 48 * $(vDays);

     

     

    Hope this helps.

     

    Regards,

    jagan.