Syntax Date.EndOfQuarter(dateTime as any) as any Description Returns a date, datetime, or datetimezone value representing the end of the quarter in dateTime. Time zone information is preserved. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.EndOfQuarter
Syntax Date.StartOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as any Description Returns the first value of the week 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.StartOfWeek
Syntax Date.EndOfYear(dateTime as any) as any Description Returns a value representing the end of the year in dateTime, including fractional seconds. Time zone information is preserved. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.EndOfYear
Syntax Date.IsInNextDay(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime 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… Read More »Date.IsInNextDay
Syntax null Description Returns 2, the number representing Monday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Day.Monday
Syntax null Description Returns 7, the number representing Saturday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Day.Saturday
Syntax Date.IsInPreviousWeek(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime 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… Read More »Date.IsInPreviousWeek
Syntax Date.IsInNextMonth(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime 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… Read More »Date.IsInNextMonth
Syntax Date.IsInPreviousQuarter(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime 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… Read More »Date.IsInPreviousQuarter
Syntax Date.DayOfWeekName(date as any, optional culture as nullable text) Description Returns the day of the week name for the provided date. An optional culture may also be provided (for example, “en-US”). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.DayOfWeekName