← Back to Date functions

Date.IsInNextMonth

This function determines if the specified date and time value occurs in the upcoming month based on the current date and time of the system. It should be noted that the function will return a false va...

Syntax

Date.IsInNextMonth(dateTime as any) as nullable logical

About

This function determines if the specified date and time value occurs in the upcoming month based on the current date and time of the system. It should be noted that the function will return a false value if the input date falls within the current month. The parameter "dateTime" should be a date, datetime, or datetimezone value that needs to be checked.

Explanation

Check if the month after the current system time is in the upcoming month. To do so, use the Power Query function MDate.IsInNextMonth with the parameter Date.AddMonths(DateTime.FixedLocalNow(), 1). The output will be true if the next month is being referenced.