← Back to Date functions

Date.IsInCurrentWeek

This function checks if the provided date and time value, dateTime, falls within the current week based on the system's current date and time. The dateTime parameter can be a date, datetime, or dateti...

Syntax

Date.IsInCurrentWeek(dateTime as any) as nullable logical

About

This function checks if the provided date and time value, dateTime, falls within the current week based on the system's current date and time. The dateTime parameter can be a date, datetime, or datetimezone value.

Explanation

Check if the present time falls within the current week using technical method Power Query MDate.IsInCurrentWeek(DateTime.FixedLocalNow()). The result will be true if the current time is within the current week.