Convert Text/Datevalue Date into number

[Mukeshy12390]

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

[echuong1 · Accepted solution]

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.