Power Query
published
Search
⌃K

Date.IsInPreviousNMonths

Date.IsInPreviousNMonths

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

Description

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

Category

Date

Examples

Determine if the month before the current system time is in the previous two months.
Date.IsInPreviousNMonths(Date.AddMonths(DateTime.FixedLocalNow(), -1), 2)
true