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

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

CDR Data Range/Crystal Reports

I am building a report using Crystal Reports and I am wondering if anyone can help me out on generating the report for a data range. Currently I am using the following query within Crystal to convert the date and time standard time but I'm not sure how I can pull a range. For this report I just need I need the the data range of 11/01/2007 through 11/30/2007.

Crystal Query

Local NumberVar sec := {CallDetailRecord.dateTimeDisconnect} ;

Local DateTimeVar dt := DateAdd('s',sec,Date(1970,1,1)) ;

DateAdd('h',-5,dt)

193
Views
0
Helpful
0
Replies