Hi all,
Hopefully a pretty easy solution is available for my newbie self - I have some timestamps that came in this format:
Fri Aug 03 2018 00:11:21 GMT-0700 (Pacific Daylight Time)
This isn't registering well in tableau, and I need to be able to segment out the Date, the Time, and the day of week (which I think can be done via the datetimeformat formula, just can't get to that step)
I'm on Alteryx 11.0. Any assistance is greatly appreciated!
Solved! Go to Solution.
Hi ponraj thanks for the speedy response - I'm on Alteryx 11.0 and can't open the workflow attached, any chance you can re-upload? Thank you!!
Hi,
Another solution would be to use RegEx to parse your time stamp, this one should do the work
([[:alpha:]]+)(?:\s)([[:alpha:]]+)(?:\s)(\d{2})(?:\s)(\d{4})(?:\s)(\d{2}:\d{2}:\d{2})
and then you can use either regular formulas to get the data as you want.