DateTime formats with Util.WriteCsv
(DateTime values are always formatted with the culture-robust YMD format.)While it makes sense to use a ISO standard date format, but it would appear that excel (or Excel 2007 at least) does not recognize such columns as dates.
Would it be possible to use ToString("yyyy-MM-dd HH:mm:ss") instead?
(When I first seen this, I thought I had must have done something wrong, but I have triple checked it and also tried it on another machine).
Comments