Quote:
Originally Posted by sarettah
[b]2. You are trying to compare a string to a date. You need to cast the strings as dates if you want a date compare. "where date between cast(date1 as date) and cast(date2 as date)"]/b]
.
|
Thanks.
I renamed the column to showdate and also redid the syntax, which is strange as StackOverFlow had tons of people saying that worked as I posted lol
Can you explain that part above for me a little? I'm not quite sure what you mean.