Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

number

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 2003 you selected Sunday (1) as the starting 
date, then January 1, 2, or 3 in 2004 would occur in week 53 of fiscal year 2003 (in 2004, 
January 1 is on a Thursday). The first day of fiscal year 2004 would be on Sunday, 
January 4, because you selected Sunday (1) as the starting day.

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.

WeekOfYearFiscal(Date(1;3;2004);1) returns 

.

WeekOfYearFiscal(Date(1;4;2004);1) returns 

.

WeekOfYearFiscal(Date(1;1;2004);5) returns 

.

Year(date)

date - any calendar date

number

Returns a number representing the year in which date occurs. For example, you can 

extract the year from a field containing the date an item sold. 

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.