ok tell me exactly what I should do, Jeff.. I'm in trouble here then..!

Ok.. Here's my query:

SELECT * FROM [MyDateTable]

WHERE StartDate >= CONVERT(DATETIME, '02/01/2007')

AND StartDate <= CONVERT(DATETIME, '01/04/2008')

This works fine, Jeff! Which is why I was saying, I used Matt's...

What's perfect is: 'Don't convert your dates to string - convert your strings to dates'

That's all i needed 🙂 cuz the query I've written uses the comparison operators '>=' and...

Perfect, Matt! That's just what I wanted. Figured it out only after i hurriedly posted the query 🙂

Thanks, Jeff!

!~! Now I have to wait for the error to occur again cuz I have no record of these error logs! One of our testers reported this to me a...

NO! I am not performing an UPDATE within the transaction!

SO.. ideally it shouldn't ever give me an error!

Like i said, it works fine almost every time.. this error is more...