Master calendar issue...

markp201 — Fri, 12 Jan 2018 21:52:16 GMT

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

Re: Master calendar issue...

Anil_Babu_Samineni — Sat, 13 Jan 2018 01:14:08 GMT

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