DateTimeZone functions

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

FunctionDescription
DateTimeZone.FixedLocalNowReturns a DateTimeZone value set to the current date, time, and timezone offset on the system.
DateTimeZone.FixedUtcNowReturns the current date and time in UTC (the GMT timezone).
DateTimeZone.FromReturns a datetimezone value from a value.
DateTimeZone.FromFileTimeReturns a DateTimeZone from a number value.
DateTimeZone.FromTextReturns a DateTimeZone value from a set of date formats and culture value.
DateTimeZone.LocalNowReturns a DateTime value set to the current system date and time.
DateTimeZone.RemoveZoneReturns a datetime value with the zone information removed from the input datetimezone value.
DateTimeZone.SwitchZoneChanges the timezone information for the input DateTimeZone.
DateTimeZone.ToLocalReturns a DateTime value from the local time zone.
DateTimeZone.ToRecordReturns a record containing parts of a DateTime value.
DateTimeZone.ToTextReturns a text value from a DateTime value.
DateTimeZone.ToUtcReturns a DateTime value to the Utc time zone.
DateTimeZone.UtcNowReturns a DateTime value set to the current system date and time in the Utc timezone.
DateTimeZone.ZoneHoursReturns a time zone hour value from a DateTime value.
DateTimeZone.ZoneMinutesReturns a time zone minute value from a DateTime value.
Show: