YEAR(date_value) YEAR(date_value) YEAR(date_value, 2-digit year switch)

 

Date Function Returns a Numeric Value
Returns the year value for the date using either the "yyyy" or "yy" format. When not using the optional 2-digit year switch, the string will be formatted as "yyyy". When using the optional 2-digit year switch, the string will be formatted as "yy" when the switch is 1 or as "yyyy" when the switch is 0. If the date_value is blank, the current system date is used. Returns 0 if the date_value is equal to "mm/dd/yyyy".

Examples:

YEAR(DATENUM( ), 1)

Returns 26 if the current system date is August 4, 2026.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)