Date.IsInNextYear

This function determines if the provided datetime value (dateTime) falls within the upcoming year based on the current date and time of the system. It is important to note that this function will retu...

Syntax

Date.IsInNextYear(dateTime as any) as nullable logical

About

This function determines if the provided datetime value (dateTime) falls within the upcoming year based on the current date and time of the system. It is important to note that this function will return false if the value falls within the current year. The input parameter, dateTime, can be a date, datetime, or datetimezone value that needs to be evaluated.

Explanation

Verify if the year following the current system time falls in the upcoming year. Employ Power Query MDate function to determine if the date one year after the current fixed local time is indeed in the next year. The expected output will be true.