Date formatting changed during data cleanser

[Dittau]

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 solution]

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

Before:

After:

[gautiergodard · Accepted solution]

Hey @Dittau 

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

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

[Dittau]

Is there a way to switch the string back to normal format after using the data cleanser tool instead?

Just curious on this way- the other way (very helpful as well!!!)

[gautiergodard]

@Dittau here is a quick and dirty way to do it.

[BS_THE_ANALYST · Accepted solution]

@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:

[Dittau]

Could you post the snips if possible…I can’t download the file.

[gautiergodard · Accepted solution]

First tool transforms string to date

Second tool transforms date to your preferred format: