DateTime

Converts a text or date value into an ISO date time.

Usage

DateTime(input)

input (required) The input to be returned as a date time. Input can be text or date. If providing a text input, it can represent a date or a date and time; acceptable formats for a text input include "yyyy-mm-dd", "mm/dd/yyyy", or "yyyy-mm-dd hh:mm:ss" (use double quotes).

Examples

DateTime("03/07/2023")

• Returns the ISO date time 2023-03-07 00:00:00.

DateTime("2023-03-07 15:27:45")

• Returns the ISO date time 2023-03-07 15:27:45.

DateTime([Text Date])

• Returns the corresponding ISO date time for each value in the [Text Date] column.