← Back to Date functions

Date.IsInCurrentQuarter

This function determines if the provided datetime value (dateTime) falls within the current quarter based on the current date and time of the system. The input parameter, dateTime, can be a date, date...

Syntax

Date.IsInCurrentQuarter(dateTime as any) as nullable logical

About

This function determines if the provided datetime value (dateTime) falls within the current quarter based on the current date and time of the system. The input parameter, dateTime, can be a date, datetime, or datetimezone value that needs to be checked.

Explanation

Check if the current system time falls within the current quarter using the Power Query function MDate.IsInCurrentQuarter(DateTime.FixedLocalNow()). The output will return either true or false.