Syntax DateTimeZone.LocalNow() as datetimezone Description Returns a datetimezone value set to the current date and time on the system. The returned value contains timezone information representing the local timezone. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone Functions / DateTimeZone.LocalNow
Syntax DateTimeZone.SwitchZone(dateTimeZone as nullable datetimezone, timezoneHours as number, optional timezoneMinutes as nullable number) as nullable datetimezone Description Changes timezone information to on the datetimezone value dateTimeZone to the new timezone information provided by timezoneHours and optionally timezoneMinutes. If dateTimeZone does not have a timezone component,… Read More »DateTimeZone.SwitchZone
Syntax #datetimezone(year as number, month as number, day as number, hour as number, minute as number, second as number, offsetHours as number, offsetMinutes as number) as any Description Creates a datetimezone value from whole numbers year year, month month, day day, hour hour, minute minute,… Read More »#datetimezone
Syntax DateTimeZone.FixedUtcNow() as datetimezone Description Returns the current date and time in UTC (the GMT timezone). This value is fixed and will not change with successive calls. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone Functions / DateTimeZone.FixedUtcNow
Syntax DateTime.IsInPreviousNMinutes(dateTime as any, minutes as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous 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.IsInPreviousNMinutes
Syntax DateTime.AddZone(dateTime as nullable datetime, timezoneHours as number, optional timezoneMinutes as nullable number) as nullable datetimezone Description Sets timezone information to on the datetime value dateTime. The timezone information will include timezoneHours and optionally timezoneMinutes. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTime Functions… Read More »DateTime.AddZone
Syntax DateTime.IsInPreviousNSeconds(dateTime as any, seconds as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous 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.IsInPreviousNSeconds
Syntax DateTime.IsInPreviousSecond(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous 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.IsInPreviousSecond
Syntax DateTime.From(value as any, optional culture as nullable text) as nullable datetime Description Returns a datetime value from the given value. An optional culture may also be provided (for example, “en-US”). If the given value is null, DateTime.From returns null. If the given value is… Read More »DateTime.From
Syntax DateTime.IsInCurrentMinute(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current minute, 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.IsInCurrentMinute