Converting string values into data format

[sebastiank88]

Hello,

I got a V_string value 45582. I would like to change this into yyyy-MM-dd format. Is there any way to do this?

ps. I dont want to create another column I would like to change the value in the exisiting one.

Best Regards,

Sebastian

[Deano478]

@sebastiank88 what date does that value correspond to?

[alexnajm · Accepted solution]

Looks like a numeric Excel date, in which case here is a solution: From excel number to date - Alteryx Community