DateTime.IsInNextHour Function in Power Query
The DateTime.IsInNextHour Function in Power Query indicates whether the given datetime value occurs during the next hour, as determined by the current date and time on the system.
Syntax
DateTime.IsInNextHour(dateTime as any) as nullable logical
- dateTime: A datetime, or datetimezone value to be evaluated.
Example: Determine if the hour after the current system time is in the next hour.
Power Query M
let Source = DateTime.IsInNextHour(DateTime.FixedLocalNow() + #duration(0, 1, 0, 0)) 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.