Tried to find some similar topics, but couldn’t find a proper solution.
I’m trying to import data from a Excel-file that has been partially exported from Revit before. That part I understand, got a simple script for that.
The last columns (J to O) are filled with information from consultants. All seems to work fine, except for the fact that same cells can contain a date. Excel then automatically changes the cell notation from standard to date. When this value is imported in the parameter, it looks like the values from the watch node on the right: MM/DD/YYYY hh:mm:ss. What I’m trying to achieve is the following notation: DD-MM-YYYY. So: 31-12-2016 or 01-01-2017 in this instance.
Is there some workaround available, or is this the best solution I can get? I’m not that much into Python to make my own script, so a little advice would be appreciated.
Excel to NCD.dyn (18.7 KB)