shagracing

Ive just seen the date!!! Don't expect any answers for this topic!!! lol :D

I cant get mine to work!! Hi this is my first post in these forums. Hello Everyone. Im using a SQL server database and the DateReported column is a date and time field. My code looks like this: rpt.DataDefinition.RecordSelectionFormula = "CDate({VehicleDefect.DateReported}) >= Date(" + startDate.Year + "," + startDate.Month + "," + startDate.Day + ") AND CDate({VehicleDefect.DateReported}) <= Date(" + endDate.Year + "," + endDate.Month + "," + endDate.Day + ")" after I had read the above posts but I get error: Message: "Cast from string "CDate({VehicleDefect.DateReporte" to type 'Double' is not valid." Can somebody please asist me in making this work!! Thanks very much Darren