One of the most frequently used functions is export to grid rows in Excel CSV format, and then I paste the data into Excel and continue my analysis further.
Most of my datetime
columns contain only dates with a zero time part. At the moment, when that part is copied to the clipboard, it is copied as e.g. "2016-01-01 00:00:00.000"
. When I paste that into Excel, the default formatting that Excel applies is HH:mm:ss
, so I see a bunch of zeroes. I have to manually change the format to yyyy-MM-dd
to see my date.
An easy fix which will save me many many format changes during to day would be to inspect the date value and if the time part is 00:00:00.000
then just copy the date part to the clipboard, i.e. "2016-01-01"
. If one pastes that into Excel, Excel autoformats it as HH:mm:ss
(or I suppose whatever the locale's date format is).