DateTime.From

DateTime

Converts a value to a datetime.

Syntax

DateTime.From(value as any, optional culture as nullable text) as nullable datetime

Parameters

Name	Type	Required	Description
`value`	`any`	Yes	The value to convert. Accepts text, date, datetimezone, and number values.
`culture`	`text`	No	Culture code for locale-specific parsing (e.g., "en-US").

Return Value

datetime — A datetime value converted from the given input.

Remarks

DateTime.From converts text, date, datetimezone, or number values into a datetime. Text values are parsed according to standard datetime formats or the specified culture. Number values are interpreted as OLE Automation dates (days since December 30, 1899). If the input is null, the function returns null.

Examples

Example 1: Convert OrderDate to datetime

Table.AddColumn(
    Table.SelectColumns(
        Table.FirstN(Sales, 4),
        {"OrderID", "OrderDate"}
    ),
    "OrderDateTime", each DateTime.From([OrderDate]), type datetime
)

Result

	OrderID	OrderDate	OrderDateTime
1	1	1/15/2024	1/15/2024 12:00:00 AM
2	2	1/18/2024	1/18/2024 12:00:00 AM
3	3	2/1/2024	2/1/2024 12:00:00 AM
4	4	2/10/2024	2/10/2024 12:00:00 AM

Example 2: Convert a text string to a datetime

#table(
    type table [Result = datetime],
    {{DateTime.From("2024-03-15 14:30:00")}}
)