DateTime.IsInPreviousMinute

DateTime

Returns true if the datetime falls in the previous clock minute.

Syntax

DateTime.IsInPreviousMinute(dateTime as any) as logical

Parameters

Name	Type	Required	Description
`dateTime`	`any`	Yes	A datetime or datetimezone value to test.

Return Value

logical — true if the datetime falls within the clock minute immediately before the current minute, false otherwise.

Remarks

DateTime.IsInPreviousMinute returns true if the input datetime or datetimezone value falls within the clock minute immediately preceding the current minute (as determined by DateTime.LocalNow()). For example, if it is currently 10:32, this function returns true for any datetime between 10:31:00 and 10:31:59.9999999. The function is re-evaluated on each query refresh.

Examples

Example 1: Filter events from the previous minute

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

Result

	EventID	EventTime
1	58	3/8/2026 10:31:05 AM
2	59	3/8/2026 10:31:50 AM

Example 2: Flag previous-minute events

Table.AddColumn(
    Events,
    "IsPreviousMinute", each DateTime.IsInPreviousMinute([EventTime]), type logical
)