Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Problem parsing a date & time,,,

dicky5150
8 - Asteroid

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

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

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,

dicky5150
8 - Asteroid

Thanks ! Worked a treat !

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

Labels