I need dates instead of week numbers
I am working on a resource planning app. We need this done a weekly basis. I currently created fields for week 1 - week 52. This would work great if we used week numbers, but I really need dates, i...
Forum Discussion
The formula for the first Saturday of the Year would be
var date TodaysDate= Today(); // done this way so you can try with different dates
var date FirstSaturdayOfYearRaw = FirstDayOfWeek(FirstDayOfYear($TodaysDate))-Days(1);
If(Year($FirstSaturdayOfYearRaw) <> Year($TodaysDate), $FirstSaturdayOfYearRaw+Weeks(1), $FirstSaturdayOfYearRaw)
The formula for the various dates for each week would be a separate field with the formula
[First Saturday of the Year] + Weeks([week number]-1)
var date TodaysDate= Today(); // done this way so you can try with different dates
var date FirstSaturdayOfYearRaw = FirstDayOfWeek(FirstDayOfYear($TodaysDate))-Days(1);
If(Year($FirstSaturdayOfYearRaw) <> Year($TodaysDate), $FirstSaturdayOfYearRaw+Weeks(1), $FirstSaturdayOfYearRaw)
The formula for the various dates for each week would be a separate field with the formula
[First Saturday of the Year] + Weeks([week number]-1)