Functions Reference

32 FileMaker Functions Reference
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 FileMaker Pro Help.
Examples
WeekOfYear(“1/1/2008”) returns 1.
WeekOfYear(ProjectDue) returns 6, when ProjectDue is 2/4/2008.
WeekOfYearFiscal
Format
WeekOfYearFiscal(date;startingDay)
Parameters
date - any calendar date
startingDay - any number between 1 and 7, where 1 represents Sunday
Data type returned
number
Description
Returns a number between 1 and 53 representing the week containing date, figured
according to startingDay. startingDay indicates which day is considered the first day
of the week.
The first week of the year is the first week that contains four or more days of that year. For
example, if you select 1 (Sunday) as the starting day, then January 1 must be on Sunday,
Monday, Tuesday, or Wednesday for that week to be the first week of the fiscal year. If
you select 2 (Monday) as the starting day, then January 1 must be on Monday, Tuesday,
Wednesday, or Thursday for that week to be the first week of the fiscal year.
It is possible, using this function, that dates in a particular year will be returned as the 53rd
week of the previous year. For example, if in 2008 you selected Sunday (1) as the starting
date, then January 1, 2, or 3 in 2009 would occur in week 53 of fiscal year 2008 (in 2009,
January 1 is on a Thursday). The first day of fiscal year 2009 would be on Sunday,
January 4, because you selected Sunday (1) as the starting day.
Important To avoid errors when using dates, always use four-digit years. For more
information about how FileMaker Pro handles two-digit dates, see FileMaker Pro Help.