DateTime.IsInPreviousMinute

This function determines if the provided datetime value, dateTime, falls within the previous minute based on the current date and time of the system. It should be noted that this function will return ...

Syntax

DateTime.IsInPreviousMinute(dateTime as any) as nullable logical

About

This function determines if the provided datetime value, dateTime, falls within the previous minute based on the current date and time of the system. It should be noted that this function will return false if a value within the current minute is passed as input. The input parameter should be a datetime or datetimezone value to be assessed.

Explanation

Verify whether the minute before the current time of the system falls within the previous minute. Syntax: Power Query MDateTime.IsInPreviousMinute(DateTime.FixedLocalNow() - #duration(0, 0, 1, 0)) Result: True