Power Query
published
Search
K
Comment on page

Date.IsInNextNWeeks

Date.IsInNextNWeeks

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

Description

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

Category

Date

Examples

Determine if the week after the current system time is in the next two weeks.
Date.IsInNextNWeeks(Date.AddDays(DateTime.FixedLocalNow(), 7), 2)
true