Date.IsInNextWeek

This function determines if a specified date and time value, dateTime, falls within the upcoming week based on the current date and time set on the system. It should be noted that when a value falls w...

Syntax

Date.IsInNextWeek(dateTime as any) as nullable logical

About

This function determines if a specified date and time value, dateTime, falls within the upcoming week based on the current date and time set on the system. It should be noted that when a value falls within the present week, the function will return false. The parameter, dateTime, can be a date, datetime, or datetimezone value that needs to be assessed.

Explanation

Check if the week following the current system time falls within the next week. Use Power Query function MDate.IsInNextWeek by adding 7 days to the current date and time obtained from DateTime.FixedLocalNow(). The output will be 'true' if the week after the current system time is indeed in the next week.