Reference > Functions reference > Date functions > Year
 

Year

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.

Example 1 

Year ( DateSold ) returns the year stored in DateSold.

Year ( "5/5/2019" ) returns 2019.

Example 2 

Returns the year that is 48 months from today's date.

Year (
   Date (
      Month ( Get ( CurrentDate ) ) + 48 ;
      Day ( Get ( CurrentDate ) ) ;
      Year ( Get ( CurrentDate ) )
   )
)

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas