Master calendar issue...

[markp201]

I'm guessing the issue with the date variables but I get zero rows in the loop

LET vMinDate=DATE(NUM(DATE#('4/1/17','M/D/YY')));

LET vMaxDate=TODAY();

[TEMP MASTER CALENDAR]:

LOAD

  AUTONUMBER(DATE($(vMinDate) + Iterno()-1),'ACTIVITYDATE') AS %ActivityDate,

  DATE($(vMinDate) + Iterno()-1) as [Activity Date],

  MONTHSTART($(vMinDate) + Iterno()-1) AS [Month Start],

  TEXT(MONTH($(vMinDate) + Iterno()-1)) AS Month,

  NUM(MONTH($(vMinDate) + Iterno()-1)) AS [Month #],

  PICK(WEEKDAY($(vMinDate) + Iterno()-1)+1,'Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday') AS [Day of Week],

  DAY($(vMinDate) + Iterno()-1) AS [Day of Month],

  MONTHNAME($(vMinDate) + Iterno()-1) AS [Month-Year],

  MONTHEND($(vMinDate) + Iterno()-1) AS [Month End],

  YEAR($(vMinDate) + Iterno()-1) AS [Year]

AUTOGENERATE 1 WHILE $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

[Anil_Babu_Samineni]

This will deserve !!

LET vMinDate=DATE(NUM(DATE#('4/1/17','M/D/YY')));

LET vMaxDate=TODAY();

[TEMP MASTER CALENDAR]:

LOAD [Activity Date],

AutoNumber([Activity Date]) as %ActivityDate,

MonthStart([Activity Date]) as [Month Start],

Text(Month([Activity Date])) as Month,

Num(Month([Activity Date])) as [Month #],

Day([Activity Date]) as [Day of Month],

MonthName([Activity Date]) as [Month-Year],

MonthEnd([Activity Date]) as [Month End],

Year([Activity Date]) as Year;

LOAD Date('$(vMinDate)' + IterNo() -1) as [Activity Date]

AutoGenerate 1

While Date('$(vMinDate)' + IterNo() -1) <= '$(vMaxDate)';