I doubt this is your actual code. Does your report contain parameters or are setting the formula in VB? Regardless, convert the strings to dates.

Crystal has several functions to do just that. CDate might work.

{tblRequest.requestDate} IN CDate('7/1/2007 7:02:55 AM') TO CDate('7/25/2007 7:02:55 AM')