Category: Date

Syntax: Year ( date )


dateAny valid date (1/1/000112/31/4000). The parameter should be a string containing a date (for example, "3/17/2004"), an expression with a date result (for example, Date (6, 29, 1969)), or an integer that represents a serialized date value (for example, 718977).

Data type returned: Number


Returns the year portion of the date parameter.

The Year() function is often used in conjunction with the Date() function to assemble new date values. For instance, if you have a field called DateOfBirth that contains someones birthdate, you can calculate the date of that persons birthday in the current year as follows:

 Date (Month (DateOfBirth), Day (DateOfBirth), Year (Get (CurrentDate)))




Year ("1/1/2004")

Returns 2004.

Year (Get(CurrentDate))

Returns the current year.

Year (myBirthdate)

Returns the year portion of the field myBirthdate.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: