text-to-datetime

text →
text-to-datetime(
    format: text,
    culture?: text
) → date-time

Returns a dateTime value matching the argument value parsed by the long format in the culture specified in parameter.

Parameters

Name	Type	Required	Description
format	text	Yes	A string representing the required format.
culture	text	No	A string representing a pre-defined culture.

Examples

"2024-01-15 12:30:00" | text-to-datetime("yyyy-MM-dd HH:mm:ss") → #"2024-01-15 12:30:00"
"01/15/2024 12:30:00" | text-to-datetime("MM/dd/yyyy HH:mm:ss", "en-US") → #"2024-01-15 12:30:00"

Kind: Function
Scope: text/conversion
Aliases: text-to-dateTime