Date Conversions

[AndersonRyan]

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. 

[CoG · Accepted solution]

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 · Accepted solution]

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

[TimN]

Maybe this?

[AndersonRyan]

Yes that works, thank you

[AndersonRyan]

Yes that works, thank you