Converting to num to date

[Jules22]

how to convert below dates to uniform date.

 

[atcodedog05]

Hi @Jules22,

Here is how you can do it.

Hope this helps : )

[Jules22]

hey thanks

please have a look here:

[atcodedog05]

Hi @Jules22 ,

Try this. Can you run it once.

Hope this helps : )

[Jules22]

hi @atcodedog05 

i still get the same error

[davidskaife]

Hi @Jules22 

What data type is Next Review Date set as in your workflow?

[Jules22]

@davidskaife, @atcodedog05  please refer, it is string 

[alexnajm]

The workflow from @atcodedog05 works for me as well, but maybe make your output a Date?

[atcodedog05]

Hi @Jules22,

Here is a slightly different way. Ideally you shouldnt be getting that error. So i am confused 😅.

 

Hope this helps : )

[Jules22]

hey @atcodedog05 ,

even this is throwing the same error for me. idk why😅. i have downloaded what you shared and ran. 

do we need to be mindful of anything else?