Functions Reference

Chapter 3
|
Date functions 33
Examples
WeekOfYearFiscal(Date(1;2;2008);1) returns 53.
WeekOfYearFiscal(Date(1;7;2008);1) returns 1.
WeekOfYearFiscal(Date(1;1;2009);5) returns 1.
Year
Format
Year(date)
Parameter
date - any calendar date
Data type returned
number
Description
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.
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
Year(DateSold) returns the year stored in DateSold.
Year(“5/5/2008”) returns 2008.
Year(Date(Month(Get(CurrentDate)) +
48;Day(Get(CurrentDate));Year(Get(CurrentDate)))) returns the year that
is 48 months from today’s date.
YearName
Format
YearName(date;format)
Parameters
date - any calendar date
format - a number (0, 1, or 2) that describes the display format
Data type returned
text