Date.IsInNextYear
DateReturns true if the date falls in the next calendar year.
Syntax
Date.IsInNextYear(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 calendar year immediately after the current year, false otherwise.
Remarks
Date.IsInNextYear returns true if the input date falls anywhere within the calendar year immediately following the current year (as determined by DateTime.LocalNow()). For example, if today is in 2026, this function returns true for any date in 2027. The function is re-evaluated on each query refresh.
This function matches exactly one year: the next calendar year from January 1 to December 31. For a broader multi-year window, use Date.IsInNextNYears. To include the current year as well, combine with or Date.IsInCurrentYear([OrderDate]).
Use this function for annual planning and budgeting scenarios where you need to identify items that fall in the upcoming fiscal or calendar year.
Examples
Example 1: Filter orders scheduled for next year
Table.SelectRows(
Sales,
each Date.IsInNextYear([OrderDate])
)OrderID | CustomerName | OrderDate | |
|---|---|---|---|
| 1 | 50 | Alice | 3/15/2027 |
| 2 | 51 | Bob | 9/22/2027 |
Example 2: Flag next-year orders
Table.AddColumn(
Sales,
"IsNextYear", each Date.IsInNextYear([OrderDate]), type logical
)OrderID | OrderDate | IsNextYear | |
|---|---|---|---|
| 1 | 42 | 3/8/2026 | FALSE |
| 2 | 50 | 3/15/2027 | TRUE |
| 3 | 55 | 1/1/2028 | FALSE |
Example 3: Summarize orders by whether they are in the current or next year
Table.AddColumn(
Sales,
"Period",
each
if Date.IsInCurrentYear([OrderDate]) then "Current Year"
else if Date.IsInNextYear([OrderDate]) then "Next Year"
else "Other",
type text
)OrderID | OrderDate | Period | |
|---|---|---|---|
| 1 | 35 | 10/10/2025 | Other |
| 2 | 42 | 3/8/2026 | Current Year |
| 3 | 50 | 3/15/2027 | Next Year |