[cisco-voip] CDR and custom reports

[Chris Beck - CEC]

Don't forget to adjust for timezone.  The formula below will only get
you to GMT

-----Original Message-----
From: Robert Kulagowski [mailto:bob at smalltime.com] 
Sent: Thursday, March 29, 2007 2:55 PM
To: Andrew F. Wolfe
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CDR and custom reports

Andrew F. Wolfe wrote:
> Hello all, this is a different kind of question for me.  If there are 
> any Crystal Reports developers out there who have done any custom CDR 
> reports, what type of formula did you use to convert the UNIX time to
a 
> readable time.  If anyone has this knowledge, I would love some help.

> Thanks. 

In Excel, the formula to convert it would be:
CDRTIME/86400+DATE(1970,1,1)

Don't know anything about CR though.