← Back to Date functions

Date.IsInNextQuarter

This function determines if the provided datetime value occurs in the next quarter based on the current date and time of the system. It should be noted that if a value falls within the current quarter...

Syntax

Date.IsInNextQuarter(dateTime as any) as nullable logical

About

This function determines if the provided datetime value occurs in the next quarter based on the current date and time of the system. It should be noted that if a value falls within the current quarter, the function will return false. The parameter dateTime refers to a date, datetime, or datetimezone value that needs to be examined.

Explanation

Verify if the quarter following the current system time falls in the subsequent quarter. Utilize Power Query function MDate.IsInNextQuarter(Date.AddQuarters(DateTime.FixedLocalNow(), 1)) The output will be true.