PowerQuery M Reference Guide
  • Accessing data functions
  • Binary functions
  • Combiner functions
  • Comparer functions
  • Date functions
    • Date.AddDays
    • Date.AddMonths
    • Date.AddQuarters
    • Date.AddWeeks
    • Date.AddYears
    • Date.Day
    • Date.DayOfWeek
    • Date.DayOfWeekName
    • Date.DayOfYear
    • Date.DaysInMonth
    • Date.EndOfDay
    • Date.EndOfMonth
    • Date.EndOfQuarter
    • Date.EndOfWeek
    • Date.EndOfYear
    • Date.From
    • Date.FromText
    • Date.IsInCurrentDay
    • Date.IsInCurrentMonth
    • Date.IsInCurrentQuarter
    • Date.IsInCurrentWeek
    • Date.IsInCurrentYear
    • Date.IsInNextDay
    • Date.IsInNextMonth
    • Date.IsInNextNDays
    • Date.IsInNextNMonths
    • Date.IsInNextNQuarters
    • Date.IsInNextNWeeks
    • Date.IsInNextNYears
    • Date.IsInNextQuarter
    • Date.IsInNextWeek
    • Date.IsInNextYear
    • Date.IsInPreviousDay
    • Date.IsInPreviousMonth
    • Date.IsInPreviousNDays
    • Date.IsInPreviousNMonths
    • Date.IsInPreviousNQuarters
    • Date.IsInPreviousNWeeks
    • Date.IsInPreviousNYears
    • Date.IsInPreviousQuarter
    • Date.IsInPreviousWeek
    • Date.IsInPreviousYear
    • Date.IsInYearToDate
    • Date.IsLeapYear
    • Date.Month
    • Date.MonthName
    • Date.QuarterOfYear
    • Date.StartOfDay
    • Date.StartOfMonth
    • Date.StartOfQuarter
    • Date.StartOfWeek
    • Date.StartOfYear
    • Date.ToRecord
    • Date.ToText
    • Date.WeekOfMonth
    • Date.WeekOfYear
    • Date.Year
    • Day.Friday
    • Day.Monday
    • Day.Saturday
    • Day.Sunday
    • Day.Thursday
    • Day.Tuesday
    • Day.Wednesday
    • #date
  • DateTime functions
  • DateTimeZone functions
  • Duration functions
  • Error handling
  • Expression functions
  • Function values
  • Lines functions
  • List functions
  • Logical functions
  • Number functions
  • Record functions
  • Replacer functions
  • Splitter functions
  • Table functions
  • Text functions
  • Time functions
  • Type functions
  • Uri functions
  • Value functions
PowerQuery M Reference Guide
  • »
  • Date functions
  • View page source

Date functions

Microsoft Docs: Date functions

About this function group.

  • Date.AddDays
  • Date.AddMonths
  • Date.AddQuarters
  • Date.AddWeeks
  • Date.AddYears
  • Date.Day
  • Date.DayOfWeek
  • Date.DayOfWeekName
  • Date.DayOfYear
  • Date.DaysInMonth
  • Date.EndOfDay
  • Date.EndOfMonth
  • Date.EndOfQuarter
  • Date.EndOfWeek
  • Date.EndOfYear
  • Date.From
  • Date.FromText
  • Date.IsInCurrentDay
  • Date.IsInCurrentMonth
  • Date.IsInCurrentQuarter
  • Date.IsInCurrentWeek
  • Date.IsInCurrentYear
  • Date.IsInNextDay
  • Date.IsInNextMonth
  • Date.IsInNextNDays
  • Date.IsInNextNMonths
  • Date.IsInNextNQuarters
  • Date.IsInNextNWeeks
  • Date.IsInNextNYears
  • Date.IsInNextQuarter
  • Date.IsInNextWeek
  • Date.IsInNextYear
  • Date.IsInPreviousDay
  • Date.IsInPreviousMonth
  • Date.IsInPreviousNDays
  • Date.IsInPreviousNMonths
  • Date.IsInPreviousNQuarters
  • Date.IsInPreviousNWeeks
  • Date.IsInPreviousNYears
  • Date.IsInPreviousQuarter
  • Date.IsInPreviousWeek
  • Date.IsInPreviousYear
  • Date.IsInYearToDate
  • Date.IsLeapYear
  • Date.Month
  • Date.MonthName
  • Date.QuarterOfYear
  • Date.StartOfDay
  • Date.StartOfMonth
  • Date.StartOfQuarter
  • Date.StartOfWeek
  • Date.StartOfYear
  • Date.ToRecord
  • Date.ToText
  • Date.WeekOfMonth
  • Date.WeekOfYear
  • Date.Year
  • Day.Friday
  • Day.Monday
  • Day.Saturday
  • Day.Sunday
  • Day.Thursday
  • Day.Tuesday
  • Day.Wednesday
  • #date
Previous Next

© Copyright 2022, Jay Bulsara.

Built with Sphinx using a theme provided by Read the Docs.