Change log file datestamp to yyyy-mm-dd
Posted: Fri Jan 04, 2013 5:39 am
I have re-edited this request:
Hard coding mm/dd/yyyy is great for USA but the rest of the world uses other formats as default. It is exceeding difficult to do an excel graph. I tried this with excel 2003 using the "text to column" conversion but it gets your date format wrong and I get a converted result assuming text is dd/mm/yy. That screws up graphing day is swapped with month. It did this in my case and probably depends on OS regional setting.
To future proof updates I suggest changing heading in log file header "Time" to literal "Time (hh:mm:ss mm/dd/yy)" so I can write an excel macro that will reformat the data for now. That change will allow me to detect the format changes in some future release. Data for last month like 12/01/12 is ambiguous depending on what your used to.
In my opinion log files should be yyyy-mm-dd hh:mm:ss (which is not necessarily what your OS regional settings are). I think excel will detect that correctly. What do others think is there a general agreement on this?
(Also noticed an extra comma on end of every CPU temperature data line which is not really needed)
Hard coding mm/dd/yyyy is great for USA but the rest of the world uses other formats as default. It is exceeding difficult to do an excel graph. I tried this with excel 2003 using the "text to column" conversion but it gets your date format wrong and I get a converted result assuming text is dd/mm/yy. That screws up graphing day is swapped with month. It did this in my case and probably depends on OS regional setting.
To future proof updates I suggest changing heading in log file header "Time" to literal "Time (hh:mm:ss mm/dd/yy)" so I can write an excel macro that will reformat the data for now. That change will allow me to detect the format changes in some future release. Data for last month like 12/01/12 is ambiguous depending on what your used to.
In my opinion log files should be yyyy-mm-dd hh:mm:ss (which is not necessarily what your OS regional settings are). I think excel will detect that correctly. What do others think is there a general agreement on this?
(Also noticed an extra comma on end of every CPU temperature data line which is not really needed)