DateTime Conversion failing

[lfaust]

Hi everyone,

I am newer to Alteryx and I am having some trouble getting the DateTime tool to convert my string in format Month dd, yyyy to mm/dd/yyyy. I did look on other posts for a solution and tried a few things but my column was still showing as null. In Excel, the date is not registered in date format. It is in general/text format and will not register as a date when I try to change it in that program.

Here is my workflow:

All of the other tools work fine and I am using them for different purposes than to change the date.

Here is the format of the dates I am trying to convert:

The type is V_WString.

TIA for the help! 😊

[atcodedog05 · Accepted solution]

Hi @lfaust 

I removed space and comma it started working. There might have some special characters.

Workflow:

Hope this helps : )

[binay2448]

Find attached solution 

[lfaust]

That worked! Thank you so much.

[atcodedog05]

Happy to help : ) @lfaust 

Cheers and have a nice day!