Converting to num to date

[Jules22]

how to convert below dates to uniform date.

 

[alexnajm]

@Jules22 at this stage please share your workflow so we can see what's happening. What version are you on?

[Jules22]

@alexnajm please look at this. i have 2024 version

[alexnajm]

@Jules22 you have just posted the workflow from before so I am not seeing an error? Or it just works fine for me - what is your error for this version of the workflow?

At this stage, try deleting your original data and reinserting it - this is very odd behavior and you might have to bring this to Alteryx Support

[binuacs · Accepted solution]

@Jules22 

[Jules22]

thank you @binuacs this works for me. @atcodedog05 @alexnajm thanks!

[atcodedog05]

Hi @Jules22,

Maybe some driver or package might have got missed. That’s why ToDate(number) might not be working 😅. But ToDate(string/date) is working based on @binuacs‘s solution.

Anyways this was a good observation and learning 😁

Happy to help : )

Cheers and have a nice day!

[binuacs]

@atcodedog05 happy to see you here :)

[atcodedog05]

@binuacs like wise :D