Date Functions

Day.Wednesday

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 …

Date.IsInPreviousMonth

Syntax Date.IsInPreviousMonth(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.IsInNextWeek

Syntax Date.IsInNextWeek(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.IsInNextNQuarters

Syntax Date.IsInNextNQuarters(dateTime as any, quarters as number) as nullable logical Description Indicates whether the given …

Date.IsInCurrentDay

Syntax Date.IsInCurrentDay(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.From

Syntax Date.From(value as any, optional culture as nullable text) as nullable date Description Returns a …

Day.Monday

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 …

Date.IsInNextDay

Syntax Date.IsInNextDay(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.EndOfYear

Syntax Date.EndOfYear(dateTime as any) as any Description Returns a value representing the end of the …

Date.StartOfWeek

Syntax Date.StartOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as any Description Returns the first …

Date.EndOfQuarter

Syntax Date.EndOfQuarter(dateTime as any) as any Description Returns a date, datetime, or datetimezone value representing …

Date.StartOfQuarter

Syntax Date.StartOfQuarter(dateTime as any) as any Description Returns the first value of the quarter

Date.IsInCurrentYear

Syntax Date.IsInCurrentYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.QuarterOfYear

Syntax Date.QuarterOfYear(dateTime as any) as nullable number Description Returns a number from 1 to 4 …

Date.AddDays

Syntax Date.AddDays(dateTime as any, numberOfDays as number) as any Description Returns the date, datetime, or …

Date.FromText

Syntax Date.FromText(text as nullable text, optional culture as nullable text) as nullable date Description Creates …

Date.DayOfWeek

Syntax Date.DayOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number Description Returns a …

Date.IsInCurrentWeek

Syntax Date.IsInCurrentWeek(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.IsInNextQuarter

Syntax Date.IsInNextQuarter(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Day.Sunday

Syntax null Description Returns 1, the number representing Sunday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Date.IsLeapYear

Syntax Date.IsLeapYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.EndOfMonth

Syntax Date.EndOfMonth(dateTime as any) as any Description Returns the last day of the month in …

Date.StartOfDay

Syntax Date.StartOfDay(dateTime as any) as any Description Returns the first value of the day dateTime. …

Date.Month

Syntax Date.Month(dateTime as any) as nullable number Description Returns the month component of the provided …

Date.StartOfYear

Syntax Date.StartOfYear(dateTime as any) as any Description Returns the first value of the year given …

Date.IsInNextNDays

Syntax Date.IsInNextNDays(dateTime as any, days as number) as nullable logical Description Indicates whether the given …

Date.DaysInMonth

Syntax Date.DaysInMonth(dateTime as any) as nullable number Description Returns the number of days in the …

Date.DayOfWeekName

Syntax Date.DayOfWeekName(date as any, optional culture as nullable text) Description Returns the day of the …

Date.IsInPreviousQuarter

Syntax Date.IsInPreviousQuarter(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.IsInNextMonth

Syntax Date.IsInNextMonth(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.IsInPreviousWeek

Syntax Date.IsInPreviousWeek(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Day.Saturday

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 …

Date.EndOfDay

Syntax Date.EndOfDay(dateTime as any) as any Description Returns a date, datetime, or datetimezone value representing …

Date.IsInCurrentQuarter

Syntax Date.IsInCurrentQuarter(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.IsInPreviousNDays

Syntax Date.IsInPreviousNDays(dateTime as any, days as number) as nullable logical Description Indicates whether the given …

Date.AddYears

Syntax Date.AddYears(dateTime as any, numberOfYears as number) as any Description Returns the date, datetime, or …

Date.MonthName

Syntax Date.MonthName(date as any, optional culture as nullable text) as nullable text Description Returns the …

Date.IsInPreviousNQuarters

Syntax Date.IsInPreviousNQuarters(dateTime as any, quarters as number) as nullable logical Description Indicates whether the given …

Date.StartOfMonth

Syntax Date.StartOfMonth(dateTime as any) as any Description Returns the first value of the month given …

Date.IsInNextYear

Syntax Date.IsInNextYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.EndOfWeek

Syntax Date.EndOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as any Description Returns the last …

Date.DayOfYear

Syntax Date.DayOfYear(dateTime as any) as nullable number Description Returns a number representing the day of …

Date.WeekOfYear

Syntax Date.WeekOfYear(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number Description Returns a …

Date.AddMonths

Syntax Date.AddMonths(dateTime as any, numberOfMonths as number) as any Description Returns the date, datetime, or …

Date.WeekOfMonth

Syntax Date.WeekOfMonth(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number Description Returns a …

Day.Friday

Syntax null Description Returns 6, the number representing Friday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Date.IsInPreviousYear

Syntax Date.IsInPreviousYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.AddQuarters

Syntax Date.AddQuarters(dateTime as any, numberOfQuarters as number) as any Description Returns the date, datetime, or …

Date.IsInNextNWeeks

Syntax Date.IsInNextNWeeks(dateTime as any, weeks as number) as nullable logical Description Indicates whether the given …

Date.IsInYearToDate

Syntax Date.IsInYearToDate(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.IsInPreviousNYears

Syntax Date.IsInPreviousNYears(dateTime as any, years as number) as nullable logical Description Indicates whether the given …

Date.ToRecord

Syntax Date.ToRecord(date as date) as record Description Returns a record containing the parts of the …

Day.Thursday

Syntax null Description Returns 5, the number representing Thursday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Date.IsInPreviousDay

Syntax Date.IsInPreviousDay(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Date.Year

Syntax Date.Year(dateTime as any) as nullable number Description Returns the year component of the provided …

Date.ToText

Syntax Date.ToText(date as nullable date, optional format as nullable text, optional culture as nullable text) …

Date.IsInPreviousNWeeks

Syntax Date.IsInPreviousNWeeks(dateTime as any, weeks as number) as nullable logical Description Indicates whether the given …

#date

Syntax #date(year as number, month as number, day as number) as date Description Creates a …

Date.IsInPreviousNMonths

Syntax Date.IsInPreviousNMonths(dateTime as any, months as number) as nullable logical Description Indicates whether the given …

Date.AddWeeks

Syntax Date.AddWeeks(dateTime as any, numberOfWeeks as number) as any Description Returns the date, datetime, or …

Date.IsInCurrentMonth

Syntax Date.IsInCurrentMonth(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime …

Day.Tuesday

Syntax null Description Returns 3, the number representing Tuesday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M …

Date.IsInNextNMonths

Syntax Date.IsInNextNMonths(dateTime as any, months as number) as nullable logical Description Indicates whether the given …

Date.Day

Syntax Date.Day(dateTime as any) as nullable number Description Returns the day component of a date, …

Date.IsInNextNYears

Syntax Date.IsInNextNYears(dateTime as any, years as number) as nullable logical Description Indicates whether the given …