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 |
Solved! Go to 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.