Date.IsInNextNDays

This function determines if a specified date and time value, dateTime, falls within the next specified number of days based on the current date and time of the system. It is important to note that thi...

Syntax

Date.IsInNextNDays(dateTime as any, days as number) as nullable logical

About

This function determines if a specified date and time value, dateTime, falls within the next specified number of days based on the current date and time of the system. It is important to note that this function will return false if the dateTime value falls within the current day. Parameters: - dateTime: A date, datetime, or datetimezone value to be checked. - days: The number of days to be considered for the evaluation of dateTime.

Explanation

Check if the date following the current system time falls within the next two days. Utilize the Power Query function MDate.IsInNextNDays, with the parameter being the date after adding one day to the current local time. This function will return a boolean output of "true" if the date is within the next two days.