1 of 1 people found this helpful
Let ( [D = Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) ) - 1 ) ;
D1 = D - DayOfWeek ( D ) + 1
D1 + Week * 7
You are a freaking Genius!! Thanks for all the past, present and future assistance.
while I checked the calculation in the data viewer plus a few glances at a calendar, I did not test with an extensive list of values and different years. Depending on how you get the week number, this expression could need adjustment for different years.