Dates from Excel

#1

Hi guys,
im reading an Excel file and the data type is set to a date in Excel but Dynamo refuses to use it :slight_smile:

0 Likes

#3

The problem is the Object.Type node, just delete it (or bypass it, simply don’t connect its output).

0 Likes

#4

Sorry i sent the wrong screen cap

Im using string and rebuilding them

0 Likes

#5

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.

1 Like