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.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!