← Back to Date functions

Date.IsInCurrentDay

This function determines if the provided dateTime value falls within the current day based on the system's current date and time. The dateTime parameter should be a date, datetime, or datetimezone val...

Syntax

Date.IsInCurrentDay(dateTime as any) as nullable logical

About

This function determines if the provided dateTime value falls within the current day based on the system's current date and time. The dateTime parameter should be a date, datetime, or datetimezone value for evaluation.

Explanation

Check if the current system time falls within the current day using the Power Query function MDate.IsInCurrentDay(DateTime.FixedLocalNow()). The output will be true if it is in the current day.