Does anyone know how to convert a date in the format yyyy/mm/dd to date value? Date value is the number of days since 1/1/1900.
Solved! Go to Solution.
Use text input to input the 1900 date value, append it to the input data using append tool and then use the DateDiff function in formula tool to find the difference between the dates.