String to DateTime conversion

[dkma]

How to convert the String " 13-Dec-2020 05:35 PM" to yyyy-mm-dd hh:mm:ss

I tried formula:

DateTimeParse("13-Dec-2020 05:35 PM", "%d-%b-%Y %H:%M %p"),

 But it is giving an error message

[Emil_Kos · Accepted solution]

Hi @dkma,

DateTimeParse("13-Dec-2020 05:35 PM", "%d-%b-%Y %I:%M %p")

I believe you need to change H to I and it will start working.

Please mark my post as a solution if this was helpful. 

[atcodedog05 · Accepted solution]

Hi @dkma 

You need to use below formula

DateTimeParse("13-Dec-2020 05:35 PM", "%d-%b-%Y %I:%M %p")

H replaced by I 

You can check the below link for the format reference

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

Hope this helps 🙂

[Emil_Kos]

Hi @atcodedog05,

I am so proud I was faster then you with a parse question. That is something new! 😄

[grazitti_sapna · Accepted solution]

Hi @dkma , another way of solving this.

Formula- dd-Mon-yyyy %I:%M %p

I hope this helps.

Thanks.

[Qiu]

@grazitti_sapna 
I did not know we can do something like this.
Thank you.😁