Custom Workflow to convert columns from string to date

[amcgill2]

Hello Alteryx community! I am hoping you can help me with the below questions as I am a super new user to Alteryx! I need to use a custom workflow to check the following:

1. Any records with DOCUMENT_DATE after RECORDING_DATE? (I think I will need to convert DOCUMENT_DATE and RECORDING_DATE from string to date data type)

Can you please help me create this workflow to answer the question accurately? 

[atcodedog05 · Accepted solution]

Hi @amcgill2 

Alteryx supports only date format in yyyy-mm-dd. Hence we need to convert them into alteryx format. We can convert into alteryx format by datetimeprase() formula and giving the current format of the date.

Workflow:

Hope this helps 🙂