Explanation please

[Anonymous]

LOAD

    $(varMinDate) + rowno() - 1 AS DateNumber,

    date ($(varMinDate) + rowno() - 1) AS TempDate

AUTOGENERATE

    $(varMaxDate) - $(varMinDate) + 1;

[#2 · Accepted solution]

varMinDate and varMaxDate indicates the min and max dates for the calendar.

AutoGenerate <N>, creates the records N times. rowno() will return the row number ie., 10th row will return interger 10.

Using these parameters, this code creates a table with date number (integer part of date time) and date starting , from min date incrementing by 1 day, (varMaxDate-varMinDate+1) times. Which will create a temp calander from min date till max date.

Hope, I clarified.

Regards,

Kiran Rokkam.