The BETWEEN..AND operator is available in MSAccess, therefore it would improve parity and provide a more familiar user experience if implemented in Kexi Reproducible: Always
Added related wish https://bugs.kde.org/show_bug.cgi?id=341736
Git commit 4a9827b1e52157fcefb700161ac80d4449be7ef1 by Roman Shtemberko. Committed on 15/12/2014 at 11:22. Pushed by rshtemberko into branch 'calligra/2.9'. Added 'BETWEEN...AND' SQL operator support in kexi queries. REVIEW:121428 M +60 -2 libs/db/expression.cpp M +4 -0 libs/db/expression.h M +884 -1048 libs/db/parser/sqlparser.cpp M +79 -93 libs/db/parser/sqlparser.h M +8 -0 libs/db/parser/sqlparser.y M +224 -194 libs/db/parser/sqlscanner.cpp M +5 -0 libs/db/parser/sqlscanner.l M +1 -0 libs/db/parser/tokens.cpp http://commits.kde.org/calligra/4a9827b1e52157fcefb700161ac80d4449be7ef1
Git commit 42ac22a7ee184d0e0ee1d248ab95e39df41bdd45 by Roman Shtemberko. Committed on 15/12/2014 at 17:58. Pushed by rshtemberko into branch 'calligra/2.9'. Added 'BETWEEN...AND' SQL operator support in kexi queries. REVIEW:121428 M +8 -2 libs/db/expression.cpp M +1 -0 libs/db/expression.h M +877 -1043 libs/db/parser/sqlparser.cpp M +80 -94 libs/db/parser/sqlparser.h M +8 -0 libs/db/parser/sqlparser.y M +214 -184 libs/db/parser/sqlscanner.cpp M +5 -0 libs/db/parser/sqlscanner.l http://commits.kde.org/calligra/42ac22a7ee184d0e0ee1d248ab95e39df41bdd45
For the record, the last commit relates to 'NOT BETWEEN...AND'. Closing.