WeekStart ( weekOfYear ; year )
Returns the date of Sunday in the specified week.
Average rating: 4.7 (28 votes) Log in to vote
|
Michael Horak - Show more from this author
*COMMENT Visual Realisation |
Sample input:
WeekStart ( 54 ; 2000 )
WeekStart ( 1 ; 2001 )
WeekStart ( 1 ; 2001 )
Sample output:
Dec 31, 2000
Dec 31, 2000
Dec 31, 2000
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns the starting date of the given week number in the given year. Week numbers are assumed to follow the same rules as specified for FileMaker's WeekOfYear() function.
This function is NOT recursive.
Comments
 |
Karen, ny May 13, 2012 |
|
| Elegant, and easily modified for fiscal! | ||
 |
John Buckingham, microGuidance Aug 31, 2012 |
|
| Nice one, Michael. Thank you... I changed the '-6' to '-5' so as to show the Monday of the week. I know this is not strictly correct, but it's what my client wanted!!! |
||
 |
Joe Leach, Bliss Media Inc May 19, 2020 |
|
| When I copy and try to save it says "the specified parameter can't be found (year)- when I try to add it, it won't let me because it has the same name as a function. I'm a little new these custom functions, help:) | ||
|
Michael Horak, *COMMENT Visual Realisation May 19, 2020 |
|
| Use a different name for the year parameter. See the discussion at https://www.briandunning.com/cf/1602. | ||
|
Michael Horak, *COMMENT Visual Realisation May 19, 2020 |
|
| Use a different name for the year parameter. See the discussion at https://www.briandunning.com/cf/1602. | ||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.