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" (please use double quotes).
Examples
DateTime("03/07/2023")
- The above will return the ISO date time 2023-03-07 00:00:00.
DateTime("2023-03-07 15:27:45")
- The example above returns the ISO date time 2023-03-07 15:27:45.
DateTime(\[Text Date\])
- The example above returns the corresponding ISO date time for each value in the [Text Date] column.
Updated 2 months ago
Related resources