Hello, I have a database field that I am pulling that is type string, but the format of each value is mm/dd/yyyy. I want to convert this to a datetime format (minus the time) so that i can compare this value to a parameter date range (begin date and
end date) that are type datetime so that i can use the calendar control in my report. i've tried in my select statement to use select.....convert(datetime, stringfieldname, 101), but I get an error that says "Conversion failed when converting datetime
to character string".
I am also open to converting the datetime parameters to strings to do the comparison, but not sure the best way to do this either.
View Complete Post