DateTimeZone functions
DateTimeZone functions functions for Power Query M language.
Functions
| Function | Description |
|---|---|
| #datetimezone | Generates a datetimezone value using numeric inputs for the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes. If any of the following conditions are n... |
| DateTimeZone.FixedLocalNow | This function retrieves the current date and time from the system and stores it as a datetime value. The value includes information about the local timezone. Unlike DateTimeZone.LocalNow, the retrieve... |
| DateTimeZone.FixedUtcNow | This function retrieves the current date and time in Coordinated Universal Time (UTC), which is equivalent to Greenwich Mean Time (GMT). The value returned by this function remains constant and will n... |
| DateTimeZone.From | This function returns a DateTimeZone value based on the input provided. It is possible to specify an optional culture parameter (e.g. "en-US"). If the input value is null, the function will also retur... |
| DateTimeZone.FromFileTime | Generates a datetimezone value by converting the fileTime value to the local time zone. FileTime is a Windows file time value that indicates the quantity of 100-nanosecond intervals passed since 12:00... |
| DateTimeZone.FromText | This function creates a datetimezone value based on a provided text representation. An optional parameter, options, can be included to specify additional properties. The options parameter can include ... |
| DateTimeZone.LocalNow | Returns a datetimezone value that is set to the current date and time on the system. The value returned includes timezone information that represents the local timezone. |
| DateTimeZone.RemoveZone | This function obtains a #datetime value from dateTimeZone, excluding the timezone information. |
| DateTimeZone.SwitchZone | Modifies the timezone information of the `dateTimeZone` value to the new timezone specified by `timezoneHours` and, if applicable, `timezoneMinutes`. If `dateTimeZone` lacks a timezone component, an e... |
| DateTimeZone.ToLocal | Adjusts the timezone data of the dateTimeZone value to match the local timezone. If dateTimeZone does not already include timezone information, the local timezone is incorporated. |
| DateTimeZone.ToRecord | This function retrieves a dataset that includes the components of the specified datetimezone value. dateTimeZone: The datetimezone value from which the dataset of its components will be generated. |
| DateTimeZone.ToText | This function generates a textual representation of a given dateTimeZone. Additionally, an optional record parameter called options can be included to specify extra properties. The culture field is on... |
| DateTimeZone.ToUtc | The function modifies the timezone information of the datetime value `dateTimeZone` to the UTC (Universal Time Coordinated) timezone. If `dateTimeZone` does not already have a timezone component, the ... |
| DateTimeZone.UtcNow | This function outputs the present date and time in the Coordinated Universal Time (UTC) timezone, also known as Greenwich Mean Time (GMT). |
| DateTimeZone.ZoneHours | Adjusts the time zone of the specified value. |
| DateTimeZone.ZoneMinutes | Adjusts the time zone of the specified value. |