Date.IsInNextDay
DateReturns true if the date is tomorrow relative to today.
Syntax
Date.IsInNextDay(dateTime as any) as logicalParameters
| Name | Type | Required | Description |
|---|---|---|---|
dateTime | any | Yes | A date, datetime, or datetimezone value to test. |
Return Value
logical — true if the date falls on tomorrow's date, false otherwise.
Remarks
Date.IsInNextDay returns true if the input date falls on the calendar day immediately following today's date (DateTime.LocalNow() + 1 day). It does not include today itself. The function is re-evaluated on each query refresh, making it useful for highlighting tomorrow's deadlines, scheduled deliveries, or upcoming events.
This function checks only a single day. To check a range of upcoming days, use Date.IsInNextNDays. For a broader window that includes today, combine Date.IsInCurrentDay and Date.IsInNextDay with an or expression.
As with all Date.IsIn* functions, the reference point is DateTime.LocalNow(). In cloud refresh environments, this is UTC-based and may not match your local "tomorrow" if you are in a different timezone.
Examples
Example 1: Filter upcoming orders due tomorrow
Table.SelectRows(
Sales,
each Date.IsInNextDay([OrderDate])
)OrderID | CustomerName | OrderDate | |
|---|---|---|---|
| 1 | 43 | Alice | 3/9/2026 |
Example 2: Flag tomorrow's orders in a boolean column
Table.AddColumn(
Sales,
"DueTomorrow", each Date.IsInNextDay([OrderDate]), type logical
)OrderID | OrderDate | DueTomorrow | |
|---|---|---|---|
| 1 | 42 | 3/8/2026 | FALSE |
| 2 | 43 | 3/9/2026 | TRUE |
| 3 | 44 | 3/15/2026 | FALSE |
Example 3: Flag today or tomorrow (two-day alert window)
Table.AddColumn(
Sales,
"AlertWindow",
each Date.IsInCurrentDay([OrderDate]) or Date.IsInNextDay([OrderDate]),
type logical
)OrderID | OrderDate | AlertWindow | |
|---|---|---|---|
| 1 | 41 | 3/7/2026 | FALSE |
| 2 | 42 | 3/8/2026 | TRUE |
| 3 | 43 | 3/9/2026 | TRUE |
| 4 | 44 | 3/15/2026 | FALSE |