DateTime.IsInNextNMinutes

This function checks if the datetime value provided in the variable "dateTime" falls within the next few minutes based on the current date and time of the system. It should be noted that the function ...

Syntax

DateTime.IsInNextNMinutes(dateTime as any, minutes as number) as nullable logical

About

This function checks if the datetime value provided in the variable "dateTime" falls within the next few minutes based on the current date and time of the system. It should be noted that the function will return a false result if the value falls within the current minute. The "dateTime" variable should contain a datetime or datetimezone value, while the variable "minutes" should specify the number of minutes to be evaluated.

Explanation

Check if the time one minute ahead of the current system time falls within the next two minutes. Function: Power Query Formula: MDateTime.IsInNextNMinutes(DateTime.FixedLocalNow() + #duration(0, 0, 2, 0), 2) Result: true