DateTime.IsInCurrentHour Function in Power Query
The DateTime.IsInCurrentHour function in Power Query indicates whether the given datetime value occurs during the current hour, as determined by the current date and time on the system.
Syntax
DateTime.IsInCurrentHour(dateTime as any) as nullable logical
- dateTime: A datetime, or datetimezone value to be evaluated.
Example: Let’s current date and time in the system is 13 April 2025 11:10AM.
Power Query M
let
Source = DateTime.IsInCurrentHour(#datetime(2025,4,13,11,40,30))
in
Source The output of the above code is TRUE.