[RESOLVED] SQL 'BETWEEN' not returning any results

[si_the_geek]

They are in Common Controls 2, along with a MonthView control which is also useful for this kind of thing.

If not I would use an IsDate() function before using the data and test it.

Unfortunately IsDate is even worse - all it tells you is that somehow the value can be implicitly converted into a date (which is true for lots of values that we can easily tell aren't actually valid input).