Convert Text/Datevalue Date into number

Question

Hi All -

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

Started_Date440634406444065440664406725-Aug-2026-Aug-2027-Aug-2028-Aug-2029-Aug-2030-Aug-2031-Aug-201-Sep-20

echuong1 · Accepted Answer

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.