Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
DateTime.AddZone
DateTime.Date
DateTime.FixedLocalNow
DateTime.From
DateTime.FromFileTime
DateTime.FromText
DateTime.IsInCurrentHour
DateTime.IsInCurrentMinute
DateTime.IsInCurrentSecond
DateTime.IsInNextHour
DateTime.IsInNextMinute
DateTime.IsInNextNHours
DateTime.IsInNextNMinutes
DateTime.IsInNextNSeconds
DateTime.IsInNextSecond
DateTime.IsInPreviousHour
DateTime.IsInPreviousMinute
DateTime.IsInPreviousNHours
DateTime.IsInPreviousNMinutes
DateTime.IsInPreviousNSeconds
DateTime.IsInPreviousSecond
DateTime.LocalNow
DateTime.Time
DateTime.ToRecord
DateTime.ToText
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By
GitBook
DateTime.FromText
DateTime.FromText
Creates a datetime from local and universal datetime formats.
function (optional
text
as nullable any, optional
culture
as nullable any) as nullable any
Description
Creates a
datetime
value from a textual representation,
text
, following ISO 8601 format standard.
Category
DateTime
Examples
Convert
"2010-12-31T01:30:25"
into a datetime value.
1
DateTime.FromText("2010-12-31T01:30:25")
Copied!
datetime(2010, 12, 31, 1, 30, 25)
Convert
"2010-12-31T01:30"
into a datetime value.
1
DateTime.FromText("2010-12-31T01:30")
Copied!
datetime(2010, 12, 31, 1, 30, 0)
Convert
"20101231T013025"
into a datetime value.
1
DateTime.FromText("20101231T013025")
Copied!
datetime(2010, 12, 31, 1, 30, 25)
Convert
"20101231T01:30:25"
into a datetime value.
1
DateTime.FromText("20101231T01:30:25")
Copied!
datetime(2010, 12, 31, 1, 30, 25)
Convert
"20101231T01:30:25.121212"
into a datetime value.
1
DateTime.FromText("20101231T01:30:25.121212")
Copied!
datetime(2010, 12, 31, 1, 30, 25.121212)
Previous
DateTime.FromFileTime
Next
DateTime.IsInCurrentHour
Copy link
Contents
DateTime.FromText
Description
Category
Examples