Converting Date Time Format

[JeffJones]

How can I convert a field format of December 1, 2022 7:13:06  AM to a new column called date that simply reads 12/1/2022?  I can't find a good example on how to perform this conversion in Alteryx.  Thank you in advance.

[JeffJones]

How can I convert a field format of December 1, 2022 7:13:06  AM to a new column called date that simply reads 12/1/2022?  I can't find a good example on how to perform this conversion in Alteryx.  Thank you in advance.

[gaoa · Accepted solution]

Hi @JeffJones 

Hope the attached answers your question.

[JeffJones]

Thank you very much.  Worked beautifully.

[gaoa · Accepted solution]

Glad to hear that @JeffJones! Could you mark this as solution? Thanks!

[ScottShimer]

This will not work if the time is 7:30 PM.   The tool will not change the hours to 19:30.