DateTime.IsInCurrentHour

Updated on

DateTime.IsInCurrentHour is a Power Query M function that indicates whether the provided date(time) value occurs during the current hour, as determined by the system.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

DateTime.IsInCurrentHour( dateTime as any ) as nullable logical

Description

DateTime.IsInCurrentHour indicates whether the given dateTime argument (which can be of type datetime or datetimezone) occurs during the current hour, as determined by the current date and time on the system.

Examples

Determine if the current system time is in the current hour.

// Output: true
DateTime.IsInCurrentHour( DateTime.FixedLocalNow() )

Other functions related to DateTime.IsInCurrentHour are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetime-isincurrenthour