help with Date functions

[eluser]Michael Wales[/eluser]
What database are you running, what version? There are a ton of solutions to this, clearly available on Google.

MySQL >= 5.0, BETWEEN works fine - make sure you CAST() to a common datatype if they are not the same. Any other version/database, do a little logically thinking...

Code:

theDate BETWEEN lowDate AND highDate

sounds a lot like

Code:

lowDate < theDate < highDate