WeekOfYear
Purpose 
Returns the number of weeks after January 1 of the year of date.
Format 
WeekOfYear(date)
Parameters 
date - any calendar date
Data type returned 
number
Description 
Fractions of weeks occurring at the beginning or end of the year count as full weeks, so the WeekOfYear function returns values 1 through 54.
Important  To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Conversion of dates with two-digit years.
Examples 
WeekOfYear(“1/1/2010”) returns 1.
WeekOfYear(ProjectDue) returns 6, when ProjectDue is 2/4/2010.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.