Power Query
Search…
Date.IsInNextNYears

Date.IsInNextNYears

Indicates whether this date occurs during the next number of years, as determined by the current date and time on the system.
function (optional dateTime as nullable any, years as number) as nullable any

Description

Indicates whether the given datetime value dateTime occurs during the next number of years, as determined by the current date and time on the system.

Category

Date

Examples

Determine if the year after the current system time is in the next two years.
Date.IsInNextNYears(Date.AddYears(DateTime.FixedLocalNow(), 1), 2)
true
Copy link
On this page
Date.IsInNextNYears
Description
Category
Examples