Filter on MM/DD/YYYY date format

[Jake5]

Hello,

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!

[Felipe_Ribeir0]

Hi @Jake5 

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.

[binuacs · Accepted solution]

@Jake5 One way of doing this

[Jake5]

Thank you!  That helped.