Syntax Date.AddWeeks(dateTime as any, numberOfWeeks as number) as any Description Returns the date, datetime, or datetimezone result from adding numberOfWeeks weeks to the 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.AddWeeks
Syntax Date.IsInPreviousNMonths(dateTime as any, months as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous number of months, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInPreviousNMonths
Syntax #date(year as number, month as number, day as number) as date Description Creates a date value from year year, month month, and day day. Raises an error if these are not true: 1 ≤ year ≤ 9999 1 ≤ month ≤ 12 1 ≤… Read More »#date
Syntax Date.IsInPreviousNWeeks(dateTime as any, weeks as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous number of weeks, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInPreviousNWeeks
Syntax Date.ToText(date as nullable date, optional format as nullable text, optional culture as nullable text) as nullable text Description Returns a textual representation of date. An optional format may be provided to customize the formatting of the text. An optional culture may also be provided… Read More »Date.ToText
Syntax Date.Year(dateTime as any) as nullable number Description Returns the year 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.Year
Syntax Date.IsInPreviousDay(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous 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.IsInPreviousDay
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 Functions / Date Functions / Day.Thursday
Syntax Date.ToRecord(date as date) as record Description Returns a record containing the parts of the given date value, date. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.ToRecord
Syntax Date.IsInPreviousNYears(dateTime as any, years as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous number of years, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInPreviousNYears