• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Log file: date wrong after month change

VinceF

New Member
Joined
Jan 26, 2015
Messages
6 (0.00/day)
Here's an excerpt from a RealTemp log file (v3.7.0.0). With the change from October to November, the date format changed and the date became wrong. What's up with that?
Code:
10/31/15,22:30:00,1680.04,48,44,49,45,1.1
10/31/15,23:00:00,1706.7,49,45,48,44,1
10/31/15,23:30:00,1733.37,48,45,48,44,1.1
2011-01-15,00:00:00,1733.37,48,46,48,45,1.1
2011-01-15,00:30:00,1960.04,48,46,48,44,2.4
2011-01-15,01:00:00,2106.71,48,45,48,45,4.2
 

VinceF

New Member
Joined
Jan 26, 2015
Messages
6 (0.00/day)
Never mind! Apparently Excel had gotten its hands on that file. The original CSV file is OK. But as soon as I open a (good) log file in Excel I see

upload_2015-11-1_13-5-31.png


and I have not been able to straighten it out by messing with Excel's formatting. Any ideas?
 
Top