DateTime.IsInNextHour

This function checks if the provided date and time value, dateTime, falls within the next hour based on the current date and time of the system. It should be noted that the function will return false ...

Syntax

DateTime.IsInNextHour(dateTime as any) as nullable logical

About

This function checks if the provided date and time value, dateTime, falls within the next hour based on the current date and time of the system. It should be noted that the function will return false if the value provided is within the current hour. The dateTime parameter can be either a datetime or datetimezone value.

Explanation

Check if the time one hour after the current system time falls within the next hour. Usage: Power Query MDateTime.IsInNextHour(DateTime.FixedLocalNow() + #duration(0, 1, 0, 0)) Output: true