Hi
I am trying to import and standard Excel file which includes a set of date fields. The date format being presented is 37993 which in excel is the 8th of Jan 2008. Does anyone have any idea how to convert these into Servoy readable dates ?
I am scripting the import so a conversion during the script is what’s required
Cheers
Gordon
I guess by summing 37993 days to the default 01/01/1904 date.
Hope this helps.
I guess by summing 37993 days to the default 01/01/1904 date.
Not really.
For starters there are 2 options 01/01/1900 and 01/01/1904.
Next to that, for whatever strange reason the outcome is not always reliable.
We have scripted the Data Plug-in so that it will recognize excel dates now.
Available starting the new release, end of this week or beginning next week…