Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Recognizing this Date Type

Highlighted
6 - Meteoroid

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?

 

Daflinders_0-1585237316359.png

 

Highlighted
Alteryx Partner
Alteryx Partner

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.

 

grossal_0-1585240207959.png

 

 

Please provide some additional information what the date and time should look like.

 

 

Best 

Alex

Highlighted
6 - Meteoroid

When I pull the data through showcase Query these are the results I get.

 

Daflinders_0-1585241001130.png

 

Highlighted
Alteryx Partner
Alteryx Partner

I got a pretty sketchy solution for you, maybe someone else will come up with something prettier.

 

grossal_0-1585241824416.png

 

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:

 

grossal_1-1585241961692.png

 

 

I'll attach my workflow. Let me know if it helps.

 

Best 

Alex

Highlighted
6 - Meteoroid

It looks like there is an unnecessary 1 added to the beginning of each date. 

Highlighted
Alteryx Partner
Alteryx Partner

I thought the same and removed it inside my workflow 😃

Labels