Home

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

Sign In or Register to comment.