DATE PARSING FROM A MONTH NAME

[kathbanc]

Hi Alteryx Community, 

Cant find the solution for this. 

Input 

Jun 7, 2023 10:00:00 PM

Output 

2023-06-07 21:00:00 

thank you all in advance

[FinnCharlton · Accepted solution]

Hi @kathbanc , you need this formula:

datetimeparse([Date],'%b %d, %Y %I:%M:%S %P')

Hope this helps!

[kathbanc]

Hi @FinnCharlton thank you so much! It works.