I would like to convert "week# = 25" to show June 18th, 2017. Can someone help with this calculation or provide me with an ExecuteSQL?
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.
Retrieving data ...