DateTime.IsInPreviousNMinutes

DateTime

Returns true if the datetime falls within the previous N clock minutes.

Syntax

DateTime.IsInPreviousNMinutes(dateTime as any, minutes as number) as logical

Parameters

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

Return Value

logical — true if the datetime falls within the N minutes before the current minute, false otherwise.

Remarks

DateTime.IsInPreviousNMinutes returns true if the input datetime or datetimezone value falls within the N complete clock minutes preceding the current minute. The current minute itself is not included; use DateTime.IsInCurrentMinute to also match the current minute. The function is re-evaluated on each query refresh.

Examples

Example 1: Filter events from the previous 15 minutes

Table.SelectRows(
    Events,
    each DateTime.IsInPreviousNMinutes([EventTime], 15)
)

Result

	EventID	EventTime
1	55	3/8/2026 10:18:00 AM
2	58	3/8/2026 10:25:00 AM

Example 2: Flag events from the past 30 minutes

Table.AddColumn(
    Events,
    "InPrev30Min", each DateTime.IsInPreviousNMinutes([EventTime], 30), type logical
)