I had this same problem, after trying various different conversions and comparisons I found this solution works, basically convert both dates to Julian numbers, not very elegant but it works!

WHERE...