DateTime.IsInNextSecond

This function is used to check if the provided datetime value occurs in the next second based on the current date and time of the system. It should be noted that the function will return false if the ...

Syntax

DateTime.IsInNextSecond(dateTime as any) as nullable logical

About

This function is used to check if the provided datetime value occurs in the next second based on the current date and time of the system. It should be noted that the function will return false if the input value falls within the current second. The input parameter for this function can be a datetime or datetimezone value that needs to be analyzed.

Explanation

Check if the time one second after the current system time falls within the next second. Syntax: Power Query MDateTime.IsInNextSecond(DateTime.FixedLocalNow() + #duration(0, 0, 0, 1)) Result: true