Archive for February, 2007
Cisco Call Manager Dates in Crystal Reports
by danlor on Feb.16, 2007, under Technology, Work
Once again, I hit a wall when trying to integrate all my databases here at work. This time, I was stymied by the fact that even though Cisco CCM runs it’s database on MS SQL server, the system does not use native date/time formats. Instead it decides to use the industry standard… number of seconds since January 1st, 1970. So I have a huge long integer. No problem right? I’ll just put it through Crystal’s formula engine. Except I get an error telling me the year is out of range.
Turns out the Crystal Date functions are based upon DAYS, not seconds. and the base date is 1900, not 1970. So, in order to make this work, I need to convert our integer from seconds to days, and then offset our number by 70 years. So what’s the solution?
CDateTime ({call manager date value}/(24*60*60)+(Date (1970, 1, 1)-Date (1900, 1, 1)))
You are welcome.
