CDR Data Range/Crystal Reports

Unanswered Question
Dec 17th, 2007
User Badges:

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)

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Actions

This Discussion