DateTime.IsInPreviousNSeconds

DateTime

Returns true if the datetime falls within the previous N seconds.

Syntax

DateTime.IsInPreviousNSeconds(dateTime as any, seconds as number) as logical

Parameters

Name	Type	Required	Description
`dateTime`	`any`	Yes	A datetime or datetimezone value to test.
`seconds`	`number`	Yes	The number of seconds back to include. Must be a positive integer.

Return Value

logical — true if the datetime falls within the N seconds before the current second, false otherwise.

Remarks

DateTime.IsInPreviousNSeconds returns true if the input datetime or datetimezone value falls within the N complete seconds preceding the current second. The current second is not included; use DateTime.IsInCurrentSecond to also match the current second. The function is re-evaluated on each query refresh.

Examples

Example 1: Filter events from the previous 30 seconds

Table.SelectRows(
    Events,
    each DateTime.IsInPreviousNSeconds([EventTime], 30)
)

Result

	EventID	EventTime
1	68	3/8/2026 10:32:16 AM
2	69	3/8/2026 10:32:40 AM

Example 2: Flag events from the past 60 seconds

Table.AddColumn(
    Events,
    "InPrev60Sec", each DateTime.IsInPreviousNSeconds([EventTime], 60), type logical
)