YearStartDate

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

Syntax

YearStartDate(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.

Examples

YearStartDate('2024-07-29') = 2024-01-01

YearStartDate('2024-07-29 02:00:00') = 2024-01-01