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
