DateTime.IsInNextMinute

This function checks if the provided datetime value dateTime falls within the next minute based on the current date and time of the system. Please be aware that when a value from the current minute is...

Syntax

DateTime.IsInNextMinute(dateTime as any) as nullable logic

About

This function checks if the provided datetime value dateTime falls within the next minute based on the current date and time of the system. Please be aware that when a value from the current minute is inputted, the function will return false. The dateTime parameter should be a datetime or datetimezone value for evaluation.

Explanation

Check if the time one minute ahead of the current system time falls within the upcoming minute. Syntax: Power Query MDateTime.IsInNextMinute(DateTime.FixedLocalNow() + #duration(0, 0, 1, 0)) Result: true