Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Time Convert Format

MattR79
8 - Asteroid

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.

 

CurrentDesired
Tue Apr 08 08:21:29 GMT 20252025-04-08
2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

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
8 - Asteroid

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

Labels
Top Solution Authors