In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

convert serial date format to yyyy-mm-dd

Ma7moud
5 - Atom

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.

 

4 REPLIES 4
Shifty
12 - Quasar

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!):

 

Shifty_2-1683549972105.png

 

Shifty_5-1683549994085.png

 

 

Shifty_3-1683549982977.png

 

Let me know if this helps!

Shifty

Shifty
12 - Quasar

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
21 - Polaris

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

binuacs_1-1683565092993.png

 

 

nagakavyasri
12 - Quasar

another way:

 

Screenshot 2023-05-09 145706.png

Labels
Top Solution Authors