[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