Yup and the date format is atorcious as well and can't be recognized by the version of Excel I'm using, so much so that I ended up building my own parser in vba code:
Public Function convertDate(text As String) As Date Dim DateArray() As String DateArray = Split(text, "/") DayPart = DateArray(0) MonthPart = DateArray(1) YearPart = Left(DateArray(2), 4) Select Case MonthPart Case "01", "1" mon = "Jan" Case "02", "2" mon = "Feb" Case "03", "3" mon = "Mar" Case "04", "4" mon = "Apr" Case "05", "5" mon = "May" Case "06", "6" mon = "Jun" Case "07", "7" mon = "Jul" Case "08", "8" mon = "Aug" Case "09", "9" mon = "Sep" Case "10" mon = "Oct" Case "11" mon = "Nov" Case "12" mon = "Dec" End Select convertDate = CDate(DayPart & " " & mon & " " & YearPart) End Function
I also noticed that online only kept history for like 3 months. Forgot to donwload data from July onwards and now I can't get detailed call logs for dates before Sep 22nd (3 months before today) anymore. Would really like an export all logs to CSV function (I use it so that I can track who I'm calling, when I'm calling and look up which days of the weeks I used too much data etc).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.