I'm building an alteryx workflow that is intended to validate if a user entered the correct date format - in this case MM/DD/YYYY - onto a input spreadsheet. My preference would be to have this work through the filter tool, where the MM/DD/YYYY records flow through the True stream and anything else flows through the False stream. Any help on what formula/function to use within the custom filter would be appreciated. Thanks!
What do you think about this idea? Convert the provided date from MM/DD/YYYY to date inside Alteryx, the "dates" that the user entered incorrect will not be converted, they will become null. Just filter the nulls.
