Dates from Excel

FAQ
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:

image
image.png1257×761 45 KB

3

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

DateTime

4

Sorry i sent the wrong screen cap

image
image.png847×750 37.9 KB

Im using string and rebuilding them

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.

TimeDate

1 Like