Hello all,
The below script creates a calendar week function (i.e. Week_Class = Current Week is the last full Monday-Sunday inclusive period)
I need to be able to adapt it so Week_Class = Current Week is the last full Thursday-Wednesday inclusive period.
Any ideas?
Thanks
MasterCalendar:
LOAD
floor(TempDate) as Link_Date,
TempDate AS mCalendarDate,
Day(TempDate) AS CalendarDay,
WeekDay(TempDate) AS CalendarWeekDay,
Week(TempDate) AS CalendarWeek,
Month(TempDate) AS CalendarMonth,
Year(TempDate) AS CalendarYear,
'Q' & Ceil(Month(TempDate)/3) AS CalendarQuarter,
WeekDay(TempDate) & '-' & Year(TempDate) AS CalendarWeekAndYear,
Month(TempDate) & '-' & Year(TempDate) AS CalendarMonthAndYear,
dual(text(date(weekend(TempDate),'DD-MMM-YY')),
if(month(weekend(TempDate))=1 and week(weekend(TempDate))=51,1,week(weekend(TempDate)))) as Nice_Week,
if(TempDate>(now()-(7)) and TempDate<(now()+1),'Previous Week') as myselector ,
TempDate as dateto,
TempDate-7 as Last_Week,
year(weekend(TempDate)) as dateto_Year,
month(TempDate) as dateto_Month,
week(weekend(TempDate)) as dateto_Week,
if(($(vDateLastWeek)-TempDate)<0,dual('Future',-1),
if(ceil(($(vDateLastWeek)-TempDate+1)/7)=1,
dual('Current Week',0),
dual('Week-'&num(ceil(($(vDateLastWeek)-TempDate+1)/7)-1,'#0'),ceil(($(vDateLastWeek)-TempDate+1)/7)-1))) as Week_Class,
num(if(($(vDateLastWeek)-TempDate)<0,dual('Future',-1),
if(ceil(($(vDateLastWeek)-TempDate+1)/7)=1,
dual('Current Week',0),
dual('Week-'&num(ceil(($(vDateLastWeek)-TempDate+1)/7)-1,'#0'),ceil(($(vDateLastWeek)-TempDate+1)/7)-1)))) as Week_ClassNum
