Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Custom CDR Reports - Date/Time Formula

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?




Re: Custom CDR Reports - Date/Time Formula

You can use the following link to change the time:

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.



New Member

Re: Custom CDR Reports - Date/Time Formula

Thanks Jorge,

I am going to try to convert this to Crystal. You wouldn't happen to know the crystal formula would you?

Re: Custom CDR Reports - Date/Time Formula

No, sorry about that. But I hope that the previous post was useful.