Load Min(TaskDate) AS MINDATE, Max(TaskDate) as maxdate Resident Tasks;
let varmindate = Num(Peek('mindate', 0, 'TEMP')); let varmaxdate = Num(Peek('maxdate', 0, 'TEMP')); drop table TEMP;
TempCalender: Load $(varmindate)+ IterNo()-1 as Num, Date($(varmindate)+ IterNo()-1 )as TempDate AutoGenerate 1 while $(varmindate)+ IterNo()-1 <= $(varmaxdate);
MasterCalender: load TempDate as TaskDate, week(TempDate) as week, Year(TempDate) as Year, Month(TempDate) as Month, Day(TempDate)as Day, ApplyMap('QuartersMap', Month(TempDate), Null()) as Quarter, week (WeekStart(TempDate))&'-'& WeekYear(TempDate)as weekYear, WeekDay(TempDate) as weekDay Resident TempCalender order by TempDate asc; Drop table TempCalender
Task Table and MasterCalender are Joined.
Any Ideas how i Join my billing Month with my master Calender so I can get Tasks for the Month.