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.
| Function | Description |
|---|---|
| DateTimeZone.FixedLocalNow | Returns a DateTimeZone value set to the current date, time, and timezone offset on the system. |
| DateTimeZone.FixedUtcNow | Returns the current date and time in UTC (the GMT timezone). |
| DateTimeZone.From | Returns a datetimezone value from a value. |
| DateTimeZone.FromFileTime | Returns a DateTimeZone from a number value. |
| DateTimeZone.FromText | Returns a DateTimeZone value from a set of date formats and culture value. |
| DateTimeZone.LocalNow | Returns a DateTime value set to the current system date and time. |
| DateTimeZone.RemoveZone | Returns a datetime value with the zone information removed from the input datetimezone value. |
| DateTimeZone.SwitchZone | Changes the timezone information for the input DateTimeZone. |
| DateTimeZone.ToLocal | Returns a DateTime value from the local time zone. |
| DateTimeZone.ToRecord | Returns a record containing parts of a DateTime value. |
| DateTimeZone.ToText | Returns a text value from a DateTime value. |
| DateTimeZone.ToUtc | Returns a DateTime value to the Utc time zone. |
| DateTimeZone.UtcNow | Returns a DateTime value set to the current system date and time in the Utc timezone. |
| DateTimeZone.ZoneHours | Returns a time zone hour value from a DateTime value. |
| DateTimeZone.ZoneMinutes | Returns a time zone minute value from a DateTime value. |
Show: