Loading Profile...
Extracted SMS Database - Time Stamp
Extracted SMS messages are showing a 10 digit number for the "time" anyway to find the date/time?
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?It's the number of seconds from Jan 1st 1970... If you copy it into excel and format that column as a date it should work.
The company says
this answers the question
-
Inappropriate?Hi Padraig,
I'm sorry but if I copy that "number of seconds to Excel and Format it nothing will happen...
I have a number like 1203616698 and try to revert it to a "real date". Can you help me? It is very important to me to have the real dates/times ... -
Inappropriate?One way of converting it to a date is with a spreadsheet program like Excel. In one cell (A1) you put the date number, in another cell (A2) you put 1-1-1970 0:00 and then you make a third cell that calculates A2+(A1/24/3600). Then add or subtract hours to convert it to your time zone.
EMPLOYEE
