SOLVED
Date Time Convert Format
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
MattR79
8 - Asteroid
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
- Tips and Tricks
2 REPLIES 2
18 - Pollux
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That worked perfectly, thank you. I was very confused as to how to parse the format.
