Wayno's latest conversations

Wayno Semiconductor
29-06-2022

Re: Usage Download date format is inconsistent in latest download

I use my last good download prior to the format change with 2 years worth of data and just copy the dates from that exactly one year earlier. I then do a global replace on the copied data changing "/2021" for "/2022". Much easier than trying to reformat all the dates........
8 Replies 0 Likes
Wayno Semiconductor
10-06-2022

Re: Usage Download date format is inconsistent in latest download

Ok, thanks. Please let us know when this is resolved!
8 Replies 0 Likes
Wayno Semiconductor
06-06-2022

Usage Download date format is inconsistent in latest download

I generally download my electricity usage data once a week and process it along with my Solar data in an Excel Spreadsheet. Unfortunately, the date format within today's download is all over the place. Mostly it's the usual format but later data has mm/dd/yyyy instead of dd/mm/yyyy. Time format changes also from hh:mm:ss (24 hr) to hh:mm:ss AM/PM (12 hr format). Then the time format changes back to 24 hour format but date format remains as mm/dd etc. It's also the first time I've received the .C ...
8 Replies 1 Like