Date formatting changed during data cleanser

Question

My date was ‘02/22/2023 going into data cleanser and it came out 02222023 after removing punctuation…i need to send the date in an email in the same normal date format just without the apostrophe…the select tool didn’t work when I switched it to date from string after data cleanser …how do i do this?

BS_THE_ANALYST · Accepted Answer

@Dittau this will work, using Replace in the formula tool:

Before:

After:

gautiergodard · Accepted Answer

Hey @Dittau

Instead of using the data cleansing tool, maybe you could do this in a formula?

replace([fieldname],"'","")

BS_THE_ANALYST · Accepted Answer

@Dittau you just need two datastreams (if you're doing the emailing within Alteryx):

Do the e-mail part on the top one, and the bottom one will remain untouched.

Alternatively, just create a duplicate of the original column in your formula tool:

gautiergodard · Accepted Answer

First tool transforms string to date

Second tool transforms date to your preferred format: