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

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.

Developer

Developer Tools

Error Message

Regex

Python

Macros

Date Time

Expression

Accepted answers

JosephSerpis

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.

Datetimeformat_16012023.yxmd

JosephSerpis

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.