Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
DateTimeZone.FixedLocalNow
DateTimeZone.FixedUtcNow
DateTimeZone.From
DateTimeZone.FromFileTime
DateTimeZone.FromText
DateTimeZone.LocalNow
DateTimeZone.RemoveZone
DateTimeZone.SwitchZone
DateTimeZone.ToLocal
DateTimeZone.ToRecord
DateTimeZone.ToText
DateTimeZone.ToUtc
DateTimeZone.UtcNow
DateTimeZone.ZoneHours
DateTimeZone.ZoneMinutes
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
DateTimeZone.FromText

DateTimeZone.FromText

Creates a datetimezone from local and universal datetime formats.
function (optional text as nullable any, optional culture as nullable any) as nullable any

Description

Creates a datetimezone value from a textual representation, text, following ISO 8601 format standard.

Category

DateTimeZone

Examples

Convert "2010-12-31T01:30:00-08:00" into a datetimezone value.
1
DateTimeZone.FromText("2010-12-31T01:30:00-08:00")
Copied!

datetimezone(2010, 12, 31, 1, 30, 0, -8, 0)

Convert "2010-12-31T01:30:00.121212-08:00" into a datetimezone value.
1
DateTimeZone.FromText("2010-12-31T01:30:00.121212-08:00")
Copied!

datetimezone(2010, 12, 31, 1, 30, 0.121212, -8, 0)

Convert "2010-12-31T01:30:00Z" into a datetimezone value.
1
DateTimeZone.FromText("2010-12-31T01:30:00Z")
Copied!

datetimezone(2010, 12, 31, 1, 30, 0, 0, 0)

Convert "20101231T013000+0800" into a datetimezone value.
1
DateTimeZone.FromText("20101231T013000+0800")
Copied!

datetimezone(2010, 12, 31, 1, 30, 0, 8, 0)

Previous
DateTimeZone.FromFileTime
Next
DateTimeZone.LocalNow
Last modified 3yr ago
Copy link
Contents
DateTimeZone.FromText
Description
Category
Examples