DateTime.IsInPreviousSecond

This function determines if the specified datetime value dateTime is from the second before the current date and time on the system. It is important to note that this function will return false if a v...

Syntax

DateTime.IsInPreviousSecond(dateTime as any) as nullable logical

About

This function determines if the specified datetime value dateTime is from the second before the current date and time on the system. It is important to note that this function will return false if a value falling within the current second is provided. The parameter dateTime should be a datetime or datetimezone value that needs to be checked.

Explanation

Verify whether the second prior to the current system time falls within the previous second by utilizing the Power Query MDateTime.IsInPreviousSecond function with the DateTime.FixedLocalNow() value subtracted by a duration of one second. The output will confirm this as true.