Returns the number of weeks after January 1 of the year of a date.
WeekOfYear ( date )
date
- any calendar date
number
FileMaker Pro 6.0 or earlier
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.
WeekOfYear ( "1/1/2019" )
returns 1.
WeekOfYear ( ProjectDue )
returns 6, when ProjectDue is 2/2/2019.
WeekOfYear ( "1/1/2019" ) - WeekOfYear ( "2/2/2019" ) returns -5.