Archive

Syntax null Description Returns 4, the number representing Wednesday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Day.Wednesday

Syntax Date.IsInPreviousMonth(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime 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… Read More »Date.IsInPreviousMonth

Syntax Date.IsInNextWeek(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime 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… Read More »Date.IsInNextWeek

Syntax Date.IsInNextNQuarters(dateTime as any, quarters as number) as nullable logical Description Indicates whether the given datetime value dateTime 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… Read More »Date.IsInNextNQuarters

Syntax Date.IsInCurrentDay(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current day, as determined by the current date and time on the system. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.IsInCurrentDay

Syntax Date.StartOfYear(dateTime as any) as any Description Returns the first value of the year given a date, datetime, or datetimezone value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.StartOfYear

Syntax Date.Month(dateTime as any) as nullable number Description Returns the month component of the provided datetime value, dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.Month

Syntax Date.StartOfDay(dateTime as any) as any Description Returns the first value of the day dateTime. dateTime must be a date, datetime, or datetimezone value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.StartOfDay

Syntax Date.EndOfMonth(dateTime as any) as any Description Returns the last day of the month in dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.EndOfMonth

Syntax Date.IsLeapYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime falls in is a leap year. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.IsLeapYear