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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Add DateTime type with milliseconds

I work with data where milliseconds is my saviour when I count distinct the datetime to get number of events. Alteryx ignores the millisecond part (as lots of other BI tool providers - I don't know what is going on with this idea that milliseconds are not needed). Yes I can convert it to string but it's not the best practice to create duplicate fields just so that I have date part for date-related calculation (plotting, time difference) and on the other hand string value for quick and easy counting..

13 Comments
Atom

I understand the implications for the generating it inside of Alteryx, but it should not be stripped from the RAW data as many processes on having the millisecond included. We would appreciate support for this.  

Alteryx
Alteryx
I just finished a macro to upload data into ArcGIS Online and Portal for ArcGIS. They only accept time as milliseconds from Unix Epoch date. Until we have milliseconds, this macro will not work with dates.
Meteoroid

I agree, need to recognize yyyy-MM-dd hh:mm:ss.SSS