Year
 
Purpose 
Returns a number representing the year in which a date occurs.
Format 
Year(date)
Parameters 
date - any calendar date
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
You can, for example, extract the year from a field containing the date an item was 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 Conversion of dates with two-digit years.
Examples 
Year(DateSold) returns the year stored in DateSold.
Year(“5/5/2014”) returns 2014.
Year(Date(Month(Get(CurrentDate)) + 48;Day(Get(CurrentDate));Year(Get(CurrentDate)))) returns the year that is 48 months from today’s date.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.