Thanks for sharing, such a mind opening post 🙂

Hi Jeff,

Thanks for your answer.

Wow incredible math equation, it actually works perfect !

Thanks 🙂

Thanks for your insight ! that was fast 🙂

so would this script be the most efficient

case
when DATEPART(WEEK,Cal_Date)=53 and DATENAME(WEEKDAY,DATEADD(yy, DATEDIFF(yy, 0, Cal_Date) + 1,...