Year

Reference > Functions reference > Date functions > Year

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.