Alteryx Designer Desktop Discussions

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

Date Conversions

AndersonRyan
5 - Atom

Hi there, 

 

I have data set that shows the date in serial number format, example - 202306100002549000. 

I need to convert this to date format. I have tried to add "."SERIAL_NUMBER" like '%20231120%' but no luck. 

 

Any suggestions? 

 

Thanks. 

5 REPLIES 5
AndrewDMerrill
13 - Pulsar

You can just use the DateTime Parse Tool (make sure your field is of string type) using:

yyyyMMddhhmmss

 

or if you just want the date:

yyyyMMdd

TimN
13 - Pulsar

What is the value you're looking for? 202306100002549000 = 2023-06-10?

TimN
13 - Pulsar

Maybe this?

AndersonRyan
5 - Atom

Yes that works, thank you

AndersonRyan
5 - Atom

Yes that works, thank you

Labels