Power Query
published
Search
⌃K

DateTime.IsInPreviousNHours

DateTime.IsInPreviousNHours

Indicates whether this datetime occurs during the previous number of hours, as determined by the current date and time on the system.
function (optional dateTime as nullable any, hours as number) as nullable any

Description

Indicates whether the given datetime value dateTime occurs during the previous number of hours, as determined by the current date and time on the system.

Category

DateTime

Examples

Determine if the hour before the current system time is in the previous two hours.
DateTime.IsInPreviousNHours(DateTime.FixedLocalNow() - #duration(0,2,0,0), 2)
true