Alteryx Designer Desktop Discussions

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

Parsing ISO8601 Formatted Dates?

6 - Meteoroid

I'm having a heck of a time parsing some really standard date formats. I've got timestamps coming out of an API in full ISO8601 format:



From what I've found, Alteryx doesn't support milliseconds or timezones, so I've had to throw down a Regex parser to tokenize the dates into their elements:



and then use a formula to pull in the values Alteryx can understand and format it:

DateTimeParse([EntryDate_Year] + "-" +
	[EntryDate_Month] + "-" +
	[EntryDate_Day] + "T" +
	[EntryDate_Hour] + ":" +
	[EntryDate_Minute] +":" +
	[EntryDate_Second] + 

Is there a better way, or a feature request I should be voting up?

12 - Quasar

The attached is a macro we use to handle these cases. Insert and use like you use other tools. Let me know if you have any questions.

17 - Castor
17 - Castor

Hey @braxtone - there are also a few ideas that you can contribute to too, several of them around decomposing or recomposing dates; and one about rethinking the way that dates are treated in Alteryx (since there are different date treatments for date parsing; date construction; date trimming; date adding; etc).


There's none that specifically addresses ISO date format, but I reckon you should add it.


Here's the full list of ideas in the IDEAS board related directly to date handlin.   Have a look at these, and it would be good to get your thoughts and support on them:



6 - Meteoroid

Thanks Sean. I wanted to make sure I wasn't missing something obvious before posting a feature request. I think the idea you put out in is a great one and responded to it.

5 - Atom

Thank, this is super helpful. Note that the original poster's data (and mine) does not have a : between the hh and mm in the timezone offset. I've attached an updated version of the macro which should handle both.