Syntax DateTime.IsInNextHour(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next 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.IsInNextHour
Syntax DateTime.Date(dateTime as any) as nullable date Description Returns the date component of dateTime, the given date, datetime, or datetimezone value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTime Functions / DateTime.Date
Syntax DateTime.FixedLocalNow() as datetime Description Returns a datetime value set to the current date and time on the system. This value is fixed and will not change with successive calls, unlike DateTime.LocalNow, which may return different values over the course of execution of an expression.… Read More »DateTime.FixedLocalNow
Syntax DateTime.IsInNextMinute(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next minute, 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.IsInNextMinute
Syntax DateTime.ToText(dateTime as nullable datetime, optional format as nullable text, optional culture as nullable text) as nullable text Description Returns a textual representation of dateTime. An optional format may be provided to customize the formatting of the text. An optional culture may also be provided… Read More »DateTime.ToText
Syntax DateTime.IsInCurrentHour(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current hour, as determined by the current date and time on the system. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTime Functions / DateTime.IsInCurrentHour
Syntax DateTime.IsInCurrentSecond(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current second, as determined by the current date and time on the system. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTime Functions / DateTime.IsInCurrentSecond
Syntax DateTime.LocalNow() as datetime Description Returns a datetime value set to the current date and time on the system. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTime Functions / DateTime.LocalNow
Syntax DateTime.IsInPreviousMinute(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous minute, 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.IsInPreviousMinute
Syntax DateTime.FromFileTime(fileTime as nullable number) as nullable datetime Description Creates a datetime value from the fileTime value and converts it to the local time zone. The filetime is a Windows file time value that represents the number of 100-nanosecond intervals that have elapsed since 12:00… Read More »DateTime.FromFileTime