In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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