DateTime.IsInNextNHours Function in Power Query

The DateTime.IsInNextNHours function in Power Query indicates whether the given datetime value occurs during the next number of hours, as determined by the current date and time on the system.

Syntax

DateTime.IsInNextNHours(dateTime as any, hours as number) as nullable logical

The function has the following parameters:

dateTime: A datetime, or datetimezone value to be evaluated.
hours: The number of hours.

Example: Determine if the hour after the current system time is in the next two hours.

Power Query M

let
    Source = DateTime.IsInNextNHours(DateTime.FixedLocalNow() + #duration(0, 2, 0, 0), 10)
in
    Source

The output of the above code is TRUE.

Note: This function will return false when passed a value that occurs within the current hour.

Previous Next