Date.IsInNextWeek
DateReturns true if the date falls in the next calendar week.
Syntax
Date.IsInNextWeek(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 in the Sunday–Saturday week immediately after the current week, false otherwise.
Remarks
Date.IsInNextWeek returns true if the input date falls within the Sunday–Saturday calendar week immediately following the current week. The current week is not included; use Date.IsInCurrentWeek to also match the current week. The function is re-evaluated on each query refresh.
The week boundary is always Sunday–Saturday. If your organization uses Monday-based weeks, there is no built-in parameter to change this — build the filter manually using Date.StartOfWeek and Date.EndOfWeek with Day.Monday.
Use this function to surface upcoming deliverables, scheduled shifts, or events planned for next week. For a broader lookahead window, use Date.IsInNextNWeeks with the desired week count.
Examples
Example 1: Filter orders scheduled for next week
Table.SelectRows(
Sales,
each Date.IsInNextWeek([OrderDate])
)OrderID | CustomerName | OrderDate | |
|---|---|---|---|
| 1 | 43 | Alice | 3/16/2026 |
| 2 | 44 | Bob | 3/18/2026 |
Example 2: Flag next-week orders
Table.AddColumn(
Sales,
"IsNextWeek", each Date.IsInNextWeek([OrderDate]), type logical
)OrderID | OrderDate | IsNextWeek | |
|---|---|---|---|
| 1 | 42 | 3/8/2026 | FALSE |
| 2 | 43 | 3/16/2026 | TRUE |
| 3 | 45 | 3/23/2026 | FALSE |
Example 3: Flag current and next week together for a two-week view
Table.AddColumn(
Sales,
"TwoWeekWindow",
each Date.IsInCurrentWeek([OrderDate]) or Date.IsInNextWeek([OrderDate]),
type logical
)OrderID | OrderDate | TwoWeekWindow | |
|---|---|---|---|
| 1 | 41 | 3/5/2026 | TRUE |
| 2 | 42 | 3/8/2026 | TRUE |
| 3 | 43 | 3/16/2026 | TRUE |
| 4 | 45 | 3/23/2026 | FALSE |