Syntax DateTime.IsInPreviousHour(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous hour, 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 »DateTime.IsInPreviousHour
Syntax #datetime(year as number, month as number, day as number, hour as number, minute as number, second as number) as any Description Creates a datetime value from whole numbers year year, month month, day day, hour hour, minute minute, and (fractional) second second. Raises an… Read More »#datetime
Syntax DateTime.IsInPreviousNHours(dateTime as any, hours as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous number of hours, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »DateTime.IsInPreviousNHours
Syntax DateTime.IsInNextNSeconds(dateTime as any, seconds as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next number of seconds, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »DateTime.IsInNextNSeconds
Syntax DateTime.IsInNextNHours(dateTime as any, hours as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next number of hours, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »DateTime.IsInNextNHours
Syntax DateTime.Time(dateTime as any) as nullable time Description Returns the time part of the given datetime value, dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTime Functions / DateTime.Time
Syntax DateTime.FromText(text as nullable text, optional culture as nullable text) as nullable datetime Description Creates a datetime value from a textual representation, text, following ISO 8601 format standard. 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… Read More »DateTime.FromText
Syntax DateTime.ToRecord(dateTime as datetime) as record Description Returns a record containing the parts of the given datetime value, dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTime Functions / DateTime.ToRecord
Syntax DateTime.IsInNextNMinutes(dateTime as any, minutes as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next number of minutes, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »DateTime.IsInNextNMinutes
Syntax DateTime.IsInNextSecond(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next second, 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 »DateTime.IsInNextSecond