Parse messy dates. Adapted from the BB Date tool (which was in turn inspired by the BB Date macro).
This tool is slower than native Alteryx tools, so is mainly recommended for datasets with mixed date formats within a single column. [See the DateTime Guide for help with date parsing.] For example, this tool will create the below "date test field_parsed" column from the "date test field" column:
Works with dates and datetimes.
This tool relies on the dateparser Python library. The important piece of code embedded within the macro is only one line:
dateparser.parse(row['date']).isoformat()[:19].replace("T", " ")