general text to date tool

AncientPandaman

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

sample workflow.yxzp

Text to Date.yxmc