[AccessD] SQL between

John Bartow john at winhaven.net
Fri Oct 26 14:37:52 CDT 2007


I have recently found a couple of issues in an app converted from A97 to
A2k3. The items of questions worked in A97 but fail in A2k3.

Problem 2. )

(Well, I guess this is more of a heads up.)

SQL between is not inclusive. So now I have to do a between DATE1 -1 and
between DATE2 +1

 

BTW I've always though it odd that it was inclusive but it seems to be many
of the SQL products but not in others. Standards!?






More information about the AccessD mailing list