Date Time Convert Format

[MattR79]

Hi All,

I have run into a wild date time format that I need to convert to an Alteryx date, the incoming format is shown here: Tue Apr 08 08:21:29 GMT 2025.  I know I need to use the datetime tool, but as this does not match any of the preset formats I was hoping someone could show me how I would plug this format into the custom option.

Current	Desired
Tue Apr 08 08:21:29 GMT 2025	2025-04-08

[alexnajm · Accepted solution]

Use a Formula instead! This worked for me: DateTimeParse([Current],"%a %b %d %H:%M:%S GMT %Y") 

Then you can do whatever you want to from there to make it just a Date - a ToDate function surrounding it should do the job

[MattR79]

That worked perfectly, thank you.  I was very confused as to how to parse the format.