← Back to Time functions

Time.StartOfHour

The function returns the beginning of the hour indicated by the dateTime input. The input dateTime must be in the form of a time, datetime, or datetimezone value.

Syntax

Time.StartOfHour(dateTime as any) as any

About

The function returns the beginning of the hour indicated by the dateTime input. The input dateTime must be in the form of a time, datetime, or datetimezone value.

Explanation

Locate the beginning of the hour for October 10th, 2011, 8:10:32AM utilizing Power Query MTime. The function used is MTime.StartOfHour(#datetime(2011, 10, 10, 8, 10, 32)). The result is displayed as #datetime(2011, 10, 10, 8, 0, 0).