WeekOfYear function

Contents > Functions reference (alphabetical list) > Date functions > WeekOfYear function

WeekOfYear function

Format


WeekOfYear(date)

Parameter

date - any calendar date

Data type returned

number

Description

Returns the number of weeks after January 1 of the year of date. 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/2008") returns 1.

WeekOfYear(ProjectDue) returns 6, when ProjectDue is 2/4/2008.

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Date functions > WeekOfYear function