Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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)';