>If, by that, you mean the date tests, would that I could. I DID have them simpler (in another part of this form) but later found I needed all these tests, otherwise hits got through that shouldn't have, or didn't where they should.
>
>Anyway, whether it's complex or not (and even slow), that's not the issue here. Sergey spotted the wrong type of BETWEEN.
>
>>Can you simplify your dates manipulations? They look too complex to me...
>>
>...
I found it too, but I think this complex condition has to be re-written. Please post the definition of what you're trying to achive with these dates, then someone may come with a better way of doing it.
If it's not broken, fix it until it is.
My Blog