community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Converting text to usable date format?

Meteor

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!

Quasar

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.PNGWorkflowResults.PNGResultsDatetimetool to convert string to date.PNGDate and Time tool to convert string to dateDate time tool to convert and date time to day.PNGDate and time tool to covert date time to day

Meteor

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!!

Quasar
 
Bolide

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.

Labels