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
Entering dates with two-digit years.
Examples
Year ( DateSold ) returns the year stored in DateSold.
Year ( "5/5/2019" ) returns 2019.
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