DATETIME PARSING

[kathbanc]

Hi! Can you help again please

Input : 

Output should be 2022-06-06  

YYYY-MM-DD 

Thank you in advance

[binu_acs · Accepted solution]

@kathbanc One way of doing this

[OllieClarke · Accepted solution]

Hi @kathbanc 

You'll need to use the datetimeparse() function, as you've got AM/PM

There's more info here https://help.alteryx.com/20231/designer/datetime-functions

But I think this is what you want:

datetimeparse([Field],"%d-%b-%y %I:%M %p")

Hope that helps,

Ollie

edit: no keeping up with @binu_acs ;)

[nagakavyasri · Accepted solution]

[kathbanc]

Thank you all so much!!! Very much appreciated