convert serial date format to yyyy-mm-dd

[Ma7moud]

Hi guys,

I m working on a dataset that contains the following column (see attachment). As you can see, the column contains serial number which is an another date format. I want to convert this serial format to the other date format yyyy-mm-dd

The column contains null values as well.

I appreciate your help.

[Shifty]

Hi @Ma7moud  

You can use either the ToDate() and ToDateTime() functions in a Formula tool to automatically convert dates (thanks to @danilang for this tip!):

Let me know if this helps!

Shifty

[Shifty]

In future. you should post your questions in the Designer Desktop Discussion board (https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/bd-p/designer-discussions).  You'll get answers faster.

Cheers,

Shifty

[binuacs]

@Ma7moud one way of converting all your data into date type

[nagakavyasri]

another way: