How to get desired Date/DateTime format using DateTime tool?

[AKPWZ]

Hi everyone, I want to convert "Date" column to "Date-Format-1", "Date-Format-2" & "Date-Format-3".

I'm using DateTime tool but it's not working for me.
Here what I'm trying to do by using the custom function of DateTime tool.
Please help me to get the expected result. Thank you!!
Attaching screenshot.

[JosephSerpis · Accepted solution]

Hi @AKPWZ I have attached a workflow that formats the dates as expected.

The following link has the specifiers for you to match your date time format to parse correctly in Alteryx.

[AKPWZ]

Thank you @JosephSerpis this formula is working for me. I think I have to use Formula tool instead of DateTime tool. 

[JosephSerpis · Accepted solution]

Hi @AKPWZ you can use the datetime tool however you would need multiple of them to achieve the same desired affect. As this is a two stage process first you need to parse your date into a format Alteryx recognises YYYY-MM-DD HH:mm:ss then you can format the date to whatever format you require. In the formula tool you can do this in a single expersion per format.

[AKPWZ]

Yes @JosephSerpis I totally agreed. Once again thanks alot!! 

[Praneeth_VC]

HI continuing to the above issue if I need 2023-1-11 rather 2023-01-11 how to do that.

[timpanister]

my solution