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.
Here is the sample workflow for your case. Hope this is helpful. There are many ways one can achieve this result. If you are stuck anywhere, just share the sample data of different combination of timestamp you have. will help you with the workflow.
Workflow
Results
Date and Time tool to convert string to date
Date and time tool to covert date time to day
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.