Syntax DateTimeZone.ToText(dateTimeZone as nullable datetimezone, optional format as nullable text, optional culture as nullable text) as nullable text Description Returns a textual representation of dateTimeZone. An optional format may be provided to customize the formatting of the text. An optional culture may also be provided… Read More »DateTimeZone.ToText
Syntax DateTimeZone.FromFileTime(fileTime as nullable number) as nullable datetimezone Description Creates a datetimezone 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 »DateTimeZone.FromFileTime
Syntax DateTimeZone.FixedLocalNow() as datetimezone Description Returns a datetime value set to the current date and time on the system. The returned value contains timezone information representing the local timezone. This value is fixed and will not change with successive calls, unlike DateTimeZone.LocalNow, which may return… Read More »DateTimeZone.FixedLocalNow
Syntax DateTimeZone.UtcNow() as datetimezone Description Returns the current date and time in UTC (the GMT timezone). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone Functions / DateTimeZone.UtcNow
Syntax DateTimeZone.From(value as any, optional culture as nullable text) as nullable datetimezone Description Returns a datetimezone value from the given value. An optional culture may also be provided (for example, “en-US”). If the given value is null, DateTimeZone.From returns null. If the given value is… Read More »DateTimeZone.From
Syntax DateTimeZone.ZoneHours(dateTimeZone as nullable datetimezone) as nullable number Description Changes the timezone of the value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone Functions / DateTimeZone.ZoneHours
Syntax DateTimeZone.FromText(text as nullable text, optional culture as nullable text) as nullable datetimezone Description Creates a datetimezone 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 »DateTimeZone.FromText
Syntax DateTimeZone.ToLocal(dateTimeZone as nullable datetimezone) as nullable datetimezone Description Changes timezone information of the datetimezone value dateTimeZone to the local timezone information. If dateTimeZone does not have a timezone component, the local timezone information is added. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone… Read More »DateTimeZone.ToLocal
Syntax DateTimeZone.RemoveZone(dateTimeZone as nullable datetimezone) as nullable datetime Description Returns a #datetime value from dateTimeZone with timezone information removed. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone Functions / DateTimeZone.RemoveZone
Syntax DateTimeZone.ToUtc(dateTimeZone as nullable datetimezone) as nullable datetimezone Description Changes timezone information of the datetime value dateTimeZone to the UTC or Universal Time timezone information. If dateTimeZone does not have a timezone component, the UTC timezone information is added. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »DateTimeZone.ToUtc