Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Convert Text/Datevalue Date into number

Mukeshy12390
8 - Asteroid

Hi All - 

 

Is there any way to convert Datevalue ( like 44063) and string date (12/13/2020) into actual date mm/dd/yyyy.

 

Started_Date
44063
44064
44065
44066
44067
25-Aug-20
26-Aug-20
27-Aug-20
28-Aug-20
29-Aug-20
30-Aug-20
31-Aug-20
1-Sep-20

 

 

 

1 REPLY 1
echuong1
Alteryx Alumni (Retired)

You have two different formats in your data. I would probably separate them first, due to them being different datatypes as well.

 

Once separated, you can use a formula tool with a datetimeadd() function to convert the numbers to date, and a datetime tool to convert the word-formatted dates to dates. After that you can use a union to create one population.

 

echuong1_0-1597933932841.png

 

Labels
Top Solution Authors