ENDYEAR( ) ENDYEAR(date_value)

 

Date Function Returns a Date Value
Returns a date value representing the last day of the year from date_value. If date_value is left blank, then the current system date is used.

Examples:

ENDYEAR(CLIENT_ID:CLOSE_DATE)

Returns 12/31/2026 if the Date Closed field in the Client file is 06/16/2026.

Returns mm/dd/yyyy if the Date Closed field in the Client file is mm/dd/yyyy.

ENDYEAR( )

Returns 12/31/2026 if the current system date is 02/18/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)