ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
Community Gallery
Create, download, and share user-built tools and workflows.Looking for Alteryx built Add-Ons?
Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.
LEARN MORE
general text to date tool
Description
convert general date format to date for multiple columns.
If error, it kept the raw data, where it safe to use without destroy the data.
and output a copy in "E" output anchor with recordID and column name.
Example:
| random date string | output | remark |
| 12/28/2015 | 2015-12-28 | converted |
| 2015-12-28 | 2015-12-28 | keep as date |
| 2028-08-24 | 2028-08-24 | keep as date |
| 2037-12-22 | 2037-12-22 | keep as date |
| December 22, 2037 | 2037-12-22 | converted |
| Feb 04, 2017 | 2017-02-04 | converted |
| Monday, 25 Dec 2025 | Monday, 25 Dec 2025 | keep as fail |
| 2023-90-02 | 2023-90-02 | keep as fail |
Edit (24 Mar 2025): bug fix as accepted "2024-18-50" as valid date
