Parse node
DateTime
Convert a column between real date/time values and formatted text.
What it does
Converts a column between real date/time values and formatted text. One way renders a Date/Time column as text in a format you choose; the other parses a text column into a genuine Date, DateTime, or Time you can sort, filter, and do date math on.
Inputs and outputs
| Inputs | One. |
| Outputs | One. |
When to use it
- Turn imported text like "07/13/2026" into a real date
- Format a date for a report, filename, or export
- Get a proper date type so a downstream Sort / Filter / Formula works
Examples
Text → Date
Text → Date/Time · MM/dd/yyyy
"07/13/2026" becomes a Date column.
Date → text
Date/Time → text · Month dd, yyyy
A date renders as "July 13, 2026".
Parse a timestamp
Text → Date/Time · yyyy-MM-dd HH:mm:ss
Has a time, so the result is a DateTime.
Tips
- Tokens: yyyy yy (year), MM (month), dd (day), Month / Mon (month name), day / dy (weekday), HH hh mm ss tt (time). Anything else is kept literally.
- Text → Date/Time picks the output type from the format: date only → Date, with a time → DateTime, time only → Time.
- A value that doesn't match the format becomes empty and the run continues, with every one counted in the run's Messages. Set “If a value cannot be read” to stop the run instead.
- Give the new column the source column's own name to replace it in place.