I have one Data set which contains only time from the server as below.
I have idea on the Datetime as Alteryx take ISO format. But i am little confused only on the Time format as seen for the First Time.
How we Parse this type of Data.
12:00 PM |
13:00 PM |
10:37 AM |
10:37 PM |
11:38 PM |
20:00 PM |
Hey @rohit782192, this can be done with the DateTime tool but I have a preference of using the Formula tool, which would look something like this:
DateTimeParse([Time],'%H:%M')
Is your incoming data automated? Just find it a little strange that it uses military time and still keeps AM/PM.
Edit: If you did want to use the DateTime tool you could just do so like this: