WeekOfYear
 
Purpose 
Returns the number of weeks after January 1 of the year of a date.
Format 
WeekOfYear(date)
Parameters 
date - any calendar date
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Fractions of weeks occurring at the beginning or end of the year count as full weeks, so the WeekOfYear function returns values 1 to 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/2014”) returns 1.
WeekOfYear(ProjectDue) returns 6, when ProjectDue is 2/2/2014.
WeekOfYear(“1/1/2014”) - WeekOfYear(“2/2/2014”) returns -5.
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.