topic Re: Filter on MM/DD/YYYY date format in Alteryx Designer Desktop Discussions

Filter on MM/DD/YYYY date format

Jake5 — Thu, 20 Oct 2022 19:32:30 GMT

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!

Re: Filter on MM/DD/YYYY date format

Felipe_Ribeir0 — Thu, 20 Oct 2022 19:54:54 GMT

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.

Re: Filter on MM/DD/YYYY date format

binu_acs — Thu, 20 Oct 2022 20:19:48 GMT

@Jake5 One way of doing this

Re: Filter on MM/DD/YYYY date format

Jake5 — Thu, 20 Oct 2022 20:36:29 GMT

Thank you! That helped.