SMS Backup & Restore wrong date stamp on sent text messages.

Discussion in 'Android Applications' started by dscrap, Oct 4, 2010.

  1. dscrap
    Offline

    dscrap New Member

    Joined:
    Aug 19, 2010
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    0
    SMS Backup & Restore - Android Stuff

    Hi all,

    I have a Droid X and I use it a lot for business texting. I needed a simple way to backup my text messages. I found SMS Backup and Restore which used to do the trick. Unfortunately since I updated to Android 2.2 all of my sent texts are off by 4 hours. I'm not sure if there is a setting to fix this, but if there is I can't find it.

    The app saves the text messages in an xml file with a date stamp that is in milli seconds. Each message has either a 1 for received or a 2 for sent in a separate column when opened in Excel. If I sort by that column to get all the sent texts in order then I can add a column and then subtract 1.44E+7 from the time stamp column and I then get the right time (minus 4 hours). I can then convert the column format to a readable date with another formula. The problem is that in Excel I have to copy all of the sent messages to a new worksheet in order to do the conversion. If I try it in the main workbook it changes the received messages as well.

    Anyone know how I can fix this problem. It didn't do it prior to the update to Android 2.2. Or do you know of a way to do it in excel easily?

    Thanks
  2. dscrap
    Offline

    dscrap New Member

    Joined:
    Aug 19, 2010
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    0
    Bump. Anyone?
  3. beebee
    Offline

    beebee New Member

    Joined:
    Oct 19, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I'm having this problem too, but I don't know how to fix it with excel... I've tried a few different backup apps and it's the same with all of them! Can anyone help?
Search tags for this page
convert android sms date format in excel
,
date stamp modifier text message
,
date stamps wrong on sms android
,

sms backup and restore date format

,
sms backup and restore restore wrong time
,

sms backup and restore time wrong

,

sms backup and restore wrong date

,

sms backup and restore wrong order

,
sms backup date wrong
,
sms backup restore date format
,
sms backup restore wrong order
,
super backup restore sms sorted wrong