DateTime.IsInCurrentHour

It checks if the provided datetime value dateTime falls within the current hour based on the current date and time on the system. The input can be a datetime or datetimezone value.

Syntax

DateTime.IsInCurrentHour(dateTime as any) as nullable logical

About

It checks if the provided datetime value dateTime falls within the current hour based on the current date and time on the system. The input can be a datetime or datetimezone value.

Explanation

Check whether the current time falls within the current hour in the system. Utilize the Power Query MDateTime function, specifying DateTime.FixedLocalNow() as the parameter within the IsInCurrentHour function. The expected output should be "true" if the current time is indeed within the current hour.