Date Formatting
Convert any date format to the ISO 8601 standard (YYYY-MM-DD).
Dates are one of the most inconsistently formatted data types. Americans write month first (01/15/2026), Europeans write day first (15/01/2026), and written formats vary endlessly. ISO 8601 is the universal standard that eliminates ambiguity.
Date (ISO 8601)
Converts any recognized date format to YYYY-MM-DD. Handles US format (MM/DD/YYYY), European format (DD-MM-YYYY), written dates (January 15, 2026), abbreviated dates (15 Jan 2026), and slash/dash/dot separators.
Before
01/15/2026
January 15, 2026
15-01-2026
2026/01/15
15 Jan 2026
After
2026-01-15
2026-01-15
2026-01-15
2026-01-15
2026-01-15
ISO 8601 dates sort correctly, work in every database, and are required by schema markup.
When to Use This
- Database imports requiring consistent date format
- Schema markup (Event, Article, Product)
- Sorting and filtering by date
- Merging datasets with different date conventions