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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Problem parsing a date & time,,,

Highlighted
Meteoroid

Hi gang,

 

My data set has a date and time stamp as follows;

 

Time In
11:52 13 Nov 2018
12:47 14 Nov 2018
08:44 15 Nov 2018
08:41 20 Nov 2018
08:34 21 Nov 2018

 

I've tried to convert from a string to an Alteryx format, but I think I'm hitting a problem with separators. Ideally I'd just like to convert this into the default Alteryx format and then I can work with it later. Can anyone direct me as to where its going wrong ?

 

Regards

 

Dicky

Alteryx Certified Partner
Alteryx Certified Partner

Hi @dicky5150 

 

I don't have Alteryx opened, but try something like this:

 

DateTimeParse([Time In], "%H:%M %d %b %Y")

 

This article can help you out: https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm

 

Cheers,

Meteoroid

Thanks ! Worked a treat !

I'm still just learning lots of this stuff !!

Labels