Filter on MM/DD/YYYY date format

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!

Data Investigation

Accepted answers

binu_acs

@Jake5 One way of doing this

DateFilter_1020.yxmd

All comments

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.

Filter on MMDDYYYY date format.yxmd

binu_acs

@Jake5 One way of doing this

DateFilter_1020.yxmd

Jake5

Thank you! That helped.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280