03-28-2007 11:52 AM - edited 03-14-2019 08:44 PM
I am trying to do some custom reporting on the CDR database with Crystal Reports 11. The problem i am having is that any time field is a long number that needs to be calculated in some way to derive the proper date/time from it. Does any one know what that formula should be?
Thanks,
JJ
03-28-2007 01:08 PM
You can use the following link to change the time:
http://www.esqsoft.com/javascript_examples/date-to-epoch.htm
But if you are looking for the fomula it is:
=A1/86400+DATE(1970,1,1) which can be used on Excel.
In cell A1 type the number that is found in the last record for DateTimeOrigination. Then in A2 paste the following formula. =A1/86400+DATE(1970,1,1). There are 86400 seconds in a day. Then right click on cell A2 and select format cells. Under the Number tab select "Time" where type is "3/14/01 1:30 PM". The result will be the actual time in readable format of the last call that was logged into the CDR.
HTH
//Jorge
03-28-2007 01:23 PM
Thanks Jorge,
I am going to try to convert this to Crystal. You wouldn't happen to know the crystal formula would you?
03-28-2007 01:27 PM
No, sorry about that. But I hope that the previous post was useful.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: