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
