DateTime.IsInCurrentSecond

DateTime.IsInCurrentSecond is a Power Query M function that indicates whether the provided date(time) value occurs during the current second. The function returns true if the value occurs within the current second, otherwise false.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

DateTime.IsInCurrentSecond( dateTime as any ) as nullable logical

Description

Indicates whether the given datetime value dateTime occurs during the current second, as determined by the current date and time on the system.

• dateTime: A datetime, or datetimezone value to be evaluated.

Examples

Determine if the current system time is in the current second.

// Output: true
DateTime.IsInCurrentSecond( DateTime.FixedLocalNow() )

Related functions

Other functions related to DateTime.IsInCurrentSecond are:

• DateTime.IsInCurrentHour
• DateTime.IsInCurrentMinute

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetime-isincurrentsecond
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.