← Back to Date functions

Date.StartOfYear

This function will return the beginning of the year in which the specified date and time falls. The input must be a valid date, date and time, or date, time, and time zone value.

Syntax

Date.StartOfYear(dateTime as any) as any

About

This function will return the beginning of the year in which the specified date and time falls. The input must be a valid date, date and time, or date, time, and time zone value.

Explanation

Locate the beginning of the year for October 10th, 2011, 8:10:32AM using Power Query MDate function. StartOfYear(#datetime(2011, 10, 10, 8, 10, 32)) will result in #datetime(2011, 1, 1, 0, 0, 0).