How to convert this date "2022-03-01" to "01/Mar/2022" using formula tool.

[Ekmi9]

How to convert this date "2022-03-01" to "01/Mar/2022" using formula tool.

Thanks in Advance !

[IraWatt]

Hey @Ekmi9,

You can use the formula tool like this:

DateTimeFormat([Date],"%d/%b/%Y")

You can use the datetime tool like this:

[DavidSkaife]

Hi @Ekmi9 

Another example using the Formula tool:

[Martyn]

DateTimeFormat([Date],"%d/%b/%Y") should do the trick.

[Ladarthure]

Hi @Ekmi9,

I won't add details about the solutions proposed by everyone, but if you want to have the details about the date time formats (using both datetimeparse tool and formula tool), you can use alteryx help about date time formats which is very simple and easy to use : 

https://help.alteryx.com/20221/designer/datetime-functions