im reading an Excel file and the data type is set to a date in Excel but Dynamo refuses to use it
The problem is the Object.Type node, just delete it (or bypass it, simply don’t connect its output).
There is no need to rebuild anything. What does the error say?
You should input only the date columns. Are they all formatted as DateTime?
You can also use List.RemoveIfNot to keep only the data formatted as date.