SQL BETWEEN If end date is less than start date all records betweenare still displayed.
in [Queries]
|
Prev: joining two iif statements
Next: SQL BETWEEN If end date is less than start date all records between are still displayed.
From: Avid Fan on 3 Apr 2010 07:24 I noticed that this query shows records the records between even if the second date is larger than the first. No big deal really I just was not expecting it. I suppose you have to code around it in case somebody makes a mistake. |