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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Problem parsing a date & time,,,

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,

Highlighted
Meteoroid

Thanks ! Worked a treat !

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

Labels