Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Is a date in a string column.

5 - Atom

I have a string column that should only have yyyy-dd-mm date formats in it, but at times it will have something like TBD.  I want to clear out anything in that column that isn't yyyy-mm-dd.  

 

Thank you

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @mtatum I mocked up a workflow that checks for both yyyy-dd-mm and yyyy-mm-dd and replaces anything that doesn't match that criteria. Let me know what you think?

 

Dates_26032020.JPG

Highlighted
15 - Aurora
15 - Aurora

@mtatum If it's a valid date format, you can use a select tool and change the type to date.

Highlighted
5 - Atom

Thank you Joseph!  Worked like a charm.

Labels