There is a problem with converting dates in Excel to csv using the 'Excel Convert' job type.
In 6.1.5 it used to convert the dates to a integer. (an OADate if you will) However between 6.1.5 and 8.0.2 the handling of dates has been changed. It now seems to try to export them as a string, presumably using the format of the original cell. However it doesn't appear to work all the time. Some styles are begin converted to strings that are of no use.
I created an Excel sheet with today's date and various formats and converted it using 8.0.2. Attached are the results.
Converting yyyy-mm-dd is really strange as Visual Cron exports this as 2016-00!
(10kb) downloaded 51 time(s).
(1kb) downloaded 52 time(s).
(1kb) downloaded 51 time(s).
Edited by moderator
| Reason: Not specified