Convert a date

[Gaetano_B]

Hi All,

I have a silly question.

I have a date in this format: 26/05/2020 and I'd like it in the following format 26-May-20.

Any suggestions?

Gaetano

[atcodedog05]

Hi @Gaetano_B 

Use

DateTimeFormat(DateTimeParse([Date],"%d/%m/%Y"),"%d-%b-%y")

in a formula tool.

[atcodedog05 · Accepted solution]

Hi @Gaetano_B 

Here is a workflow for the task.

Output:

Workflow:

DateTimeFormat(DateTimeParse([Date],"%d/%m/%Y"),"%d-%b-%y")

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu · Accepted solution]

@Gaetano_B 
in case the coming data is string, you can do like this.

@atcodedog05 

Single quote is missing, dude.

[Qiu]

@atcodedog05 
Already fixed while I was typing...😁

[atcodedog05]

Happy to help 🙂 @Gaetano_B 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂

[wtahir]

@Qiu @atcodedog05 

I have a related question. I am struggling since yesterday already to deal with this problem. My dates are in verious formats like:

2009-1-24
05-24-2015
24-01-2015
march-2019
Feb,2020
January-16th-2020
2019-March
2019, May

How can I bring them all into a same format e.g (yyyy-mm-dd) ? I went through many date time related posts but never found any post dealing with this complexity. Could you guys please help me out here?

[atcodedog05]

Hi @wtahir 

Can you post it as a new question we will be happy to help 🙂

[wtahir]

thank you for replying @atcodedog05 , here is the link to my question with title "Complex date converison":

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Complex-date-converison/td-p/668701 

Your help is much appreciated