make sure you make it a date-datatype instead of a string using cast or convert

Comparing dates with strings is usually a recipe for disaster