← Back to Date functions

Date.IsInCurrentMonth

This function checks if the specified datetime value dateTime falls within the current month based on the current date and time of the system. The parameter dateTime refers to a date, datetime, or dat...

Syntax

Date.IsInCurrentMonth(dateTime as any) as nullable logical

About

This function checks if the specified datetime value dateTime falls within the current month based on the current date and time of the system. The parameter dateTime refers to a date, datetime, or datetimezone value that needs to be assessed.

Explanation

Verify whether the current system time falls within the current month using the Power Query MDate function. The output will be "true" if the current system time is within the current month.