Date
Date Parser
Reads a column of dates that may be written in several formats — Oct 15, 26 in one row, 03/11/2026 in the next — and rewrites them all in one format.
When to use it
Use it when a column mixes date formats, typically after merging files from different systems. For a column in one known format, Date Format does the same job with a single From format.
In a pipeline
File InputDate ParserExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Input formats (one per line) | textarea | — | Leave empty to auto-detect, or e.g. MMM DD, YY DD/MM/YYYY |
| To Format | select | — | YYYY-MM-DD |
Example
Two formats into ISO dates
- Column=Ordered
- Input formats (one per line)=MMM DD, YY / DD/MM/YYYY
- To Format=YYYY-MM-DD
| Order | Ordered |
|---|---|
| A-1 | Oct 15, 26 |
| A-2 | 03/11/2026 |
| A-3 | Nov 2, 26 |
| Order | Ordered |
|---|---|
| A-1 | 2026-10-15 |
| A-2 | 2026-11-03 |
| A-3 | 2026-11-02 |
Worth knowing
- Formats are tried in the order listed and the first that matches exactly wins, so put the most specific first. Each line uses the same tokens as Date Format: YYYY, YY, MM, MMM, DD, HH, mm, ss, or UNIX / ISO.
- Leave the formats empty to auto-detect each value (ISO, day-first numbers, month names, timestamps).
- A few unreadable cells are blanked and listed in the preview; if most of the column cannot be read, the run stops and says the column is not a date column.