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)