DateTime.IsInCurrentMinute

DateTime

Returns true if the datetime falls within the current minute.

Syntax

DateTime.IsInCurrentMinute(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 current clock minute, false otherwise.

Remarks

DateTime.IsInCurrentMinute returns true if the input datetime or datetimezone value falls within the same clock minute as now (as determined by DateTime.LocalNow()). The minute window runs from HH:MM:00 to HH:MM:59.9999999. The function is re-evaluated on each query refresh.

Examples

Example 1: Filter events from the current minute

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

Result

	EventID	EventTime
1	45	3/8/2026 10:32:15 AM
2	46	3/8/2026 10:32:50 AM

Example 2: Flag current-minute rows

Table.AddColumn(
    Events,
    "IsCurrentMinute", each DateTime.IsInCurrentMinute([EventTime]), type logical
)