Problem parsing a date & time,,,

[dicky5150]

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

[Thableaus · Accepted solution]

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]

Thanks ! Worked a treat !

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