This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When using a showcase query, this data is stored as a more typical date type but when I pull in to alteryx the date seems to be unrecognizable. Anyone know what this date type is? and how I convert it in to something recognizable?
I got a pretty sketchy solution for you, maybe someone else will come up with something prettier.
The time conversion is pretty simple and less sketchy. I add a 0 in front if it's only 5 characters long and use the DateTime Tool to convert it to a time.
It's getting sketchy here. I don't know where the first '1' comes from, but I have removed it and replaced it with '20' because the characters behind it are representing the 20XX years. The numbers behind are month/date.