YearEndDate

Returns the date of the last day of the year in which date or timestamp occurs.

Syntax

YearEndDate(Date/Time)

Where

Date/Time is the input date or timestamp.

For information on the syntax used in your specific database, refer to the Functions Reference.

Example

YearEndDate('2024-07-29') = 2024-12-31

YearEndDate('2024-07-29 02:00:00') = 2024-12-31