Date Time Convert Format

Question

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.

CurrentDesiredTue Apr 08 08:21:29 GMT 20252025-04-08

alexnajm · Accepted Answer

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