Find all possible date format by Regex
Use FME attribute creator to filter all possible date format, then use FME function parseDate to convert into single FME-default-date-format and store in a new column named "Src_Date_padus"
Step 1
Step 2
use this updated version
do not use this, did not handle null or empty string, will cause error
Do not use this, 20230000 will cause error downstream translation
Step 3 check final result, all possible date format should be translate into single FME default date format and store in a new column.
Reference
Different date formats in the same date column
https://community.safe.com/s/question/0D54Q000080hQW0SAM/different-date-formats-in-the-same-date-column
Convert different date formats in same attribute
https://community.safe.com/s/question/0D54Q000080hZH7SAM/convert-different-date-formats-in-same-attribute
Regex to match date formats DD-MM-YYYY and DD/MM/YYYY
https://stackoverflow.com/questions/42355995/regex-to-match-date-formats-dd-mm-yyyy-and-dd-mm-yyyy
Regex to validate date formats dd/mm/YYYY
https://stackoverflow.com/questions/15491894/regex-to-validate-date-formats-dd-mm-yyyy-dd-mm-yyyy-dd-mm-yyyy-dd-mmm-yyyy
Regex date validation for yyyy-mm-dd
https://stackoverflow.com/questions/22061723/regex-date-validation-for-yyyy-mm-dd
Regular Expression Match to test for a valid year
https://stackoverflow.com/questions/4374185/regular-expression-match-to-test-for-a-valid-year