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 …