DateOfWeek ( week ; yearOfWeek ; type )
Calculate the first date of a given week and year
Average rating: 4.0 (42 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
When you only have the week number and a year and you need to know a date in that week, this function calculates the date of the first day of that week. It also takes in account the prefered starting day.
Mark Rubenste, Evanston, IL
Dec 29, 2014
This CF worked for week 1 last year (2014), but is one week off this year (2015). I think the the last line of code should be this:
xFirstYearDate + ( ( week - If ( xFirstWeekDay > 6 ; 0 ; 1 ) ) * 7 ) - xFirstWeekDay + 1
xFirstYearDate + ( ( week - If ( xFirstWeekDay > 4 ; 0 ; 1 ) ) * 7 ) - xFirstWeekDay + 1
In other words, > 4 should be > 6.
Am I correct?
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.