Date.IsInNextMonth
DateReturns true if the date falls in the next calendar month.
Syntax
Date.IsInNextMonth(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 month immediately after the current month, false otherwise.
Remarks
Date.IsInNextMonth returns true if the input date falls within the calendar month immediately after the current month (as determined by DateTime.LocalNow()). For example, if today is in March, this function returns true for any date in April — including dates beyond the current day in April. The function is re-evaluated on each query refresh.
This function is useful for surfacing upcoming renewals, upcoming billing cycles, or forward-looking pipeline data. It matches exactly one month: the next calendar month, not the next 30 days. For a 30-day rolling lookahead, use Date.IsInNextNDays(30) instead.
For a broader forward window spanning multiple months, use Date.IsInNextNMonths with the desired number of months.
Examples
Example 1: Filter next month's renewals
Table.SelectRows(
Subscriptions,
each Date.IsInNextMonth([RenewalDate])
)SubID | RenewalDate | Customer | |
|---|---|---|---|
| 1 | 12 | 4/10/2026 | Contoso |
| 2 | 15 | 4/25/2026 | Fabrikam |
Example 2: Flag next-month orders in Sales table
Table.AddColumn(
Sales,
"IsNextMonth", each Date.IsInNextMonth([OrderDate]), type logical
)OrderID | OrderDate | IsNextMonth | |
|---|---|---|---|
| 1 | 42 | 3/8/2026 | FALSE |
| 2 | 43 | 4/10/2026 | TRUE |
| 3 | 44 | 5/20/2026 | FALSE |
Example 3: Count orders expected next month
List.Count(
Table.SelectRows(Sales, each Date.IsInNextMonth([OrderDate]))[OrderID]
)Result | |
|---|---|
| 1 | 3 |