Date - Power Query

📄️Date.AddQuarters

Adds the specified quarters to the date.

📄️Date.DayOfWeek

Returns a number (from 0 to 6) indicating the day of the week of the provided value.

📄️Date.DayOfYear

Returns a number from 1 to 366 representing the day of the year.

📄️Date.DaysInMonth

Returns a number from 28 to 31 indicating the number of days in the month.

📄️Date.FromText

Creates a Date from local, universal, and custom Date formats.

📄️Date.IsInCurrentDay

Indicates whether this date occurs during the current day, as determined by the current date and time on the system.

📄️Date.IsInCurrentMonth

Indicates whether this date occurs during the current month, as determined by the current date and time on the system.

📄️Date.IsInCurrentQuarter

Indicates whether this date occurs during the current quarter, as determined by the current date and time on the system.

📄️Date.IsInCurrentWeek

Indicates whether this date occurs during the current week, as determined by the current date and time on the system.

📄️Date.IsInCurrentYear

Indicates whether this date occurs during the current year, as determined by the current date and time on the system.

Indicates whether this date occurs during the next day, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current day.

📄️Date.IsInNextMonth

Indicates whether this date occurs during the next month, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current month.

📄️Date.IsInNextNDays

Indicates whether this date occurs during the next number of days, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current day.

📄️Date.IsInNextNMonths

Indicates whether this date occurs during the next number of months, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current month.

📄️Date.IsInNextNQuarters

Indicates whether this date occurs during the next number of quarters, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current quarter.

📄️Date.IsInNextNWeeks

Indicates whether this date occurs during the next number of weeks, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current week.

📄️Date.IsInNextNYears

Indicates whether this date occurs during the next number of years, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current year.

📄️Date.IsInNextQuarter

Indicates whether this date occurs during the next quarter, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current quarter.

📄️Date.IsInNextWeek

Indicates whether this date occurs during the next week, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current week.

📄️Date.IsInNextYear

Indicates whether this date occurs during the next year, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current year.

📄️Date.IsInPreviousDay

Indicates whether this date occurs during the previous day, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current day.

📄️Date.IsInPreviousMonth

Indicates whether this date occurs during the previous month, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current month.

📄️Date.IsInPreviousNDays

Indicates whether this date occurs during the previous number of days, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current day.

📄️Date.IsInPreviousNMonths

Indicates whether this date occurs during the previous number of months, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current month.

📄️Date.IsInPreviousNQuarters

Indicates whether this date occurs during the previous number of quarters, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current quarter.

📄️Date.IsInPreviousNWeeks

Indicates whether this date occurs during the previous number of weeks, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current week.

📄️Date.IsInPreviousNYears

Indicates whether this date occurs during the previous number of years, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current year.

📄️Date.IsInPreviousQuarter

Indicates whether this date occurs during the previous quarter, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current quarter.

📄️Date.IsInPreviousWeek

Indicates whether this date occurs during the previous week, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current week.

📄️Date.IsInPreviousYear

Indicates whether this date occurs during the previous year, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current year.

📄️Date.IsInYearToDate

Indicates whether this date occurs during the current year and is on or before the current day, as determined by the current date and time on the system.