ENDOFYEAR Returns the last date of the year in the current context for the specified column of dates.
Dates – A column that contains dates.
Year_end_date (optional) – A literal string with a date that defines the year-end date. The default is December 31.
A table containing a single column and single row with a date value.