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?
Solved! Go to Solution.
Hi @Daflinders,
can you provide a screenshot with "how it should look like"?
I thought it might be the day as an integer like it is in Excel. But when I converted it back, I got 17.05.5077 and that's probably wrong.
I tried something similar for the UPDTM with time in seconds and it actually works for the first two, but than fails again because the number is too great.
Please provide some additional information what the date and time should look like.
Best
Alex
When I pull the data through showcase Query these are the results I get.
I got a pretty sketchy solution for you, maybe someone else will come up with something prettier.
Times:
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.
Date:
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.
Output:
I'll attach my workflow. Let me know if it helps.
Best
Alex
It looks like there is an unnecessary 1 added to the beginning of each date.
I thought the same and removed it inside my workflow 😃