Hi,
Try the following
SELECT * FROM PhotraxBaseData WHERE dateTimeTaken BETWEEN CONVERT(DATETIME,'2009-11-11') AND CONVERT(DATETIME,'2014-11-11');
In your example, you are checking the string value with the datetime variable so it may not gives the correct answer..
While using Datetime Checking in sql , consider that the given date format is in YYYY-mm--dd format -- it avoids the confusion to user and sql server system...
For Sql Lite:
SELECT * FROM PhotraxBaseData WHERE dateTimeTaken BETWEEN '2009-11-11' AND '2014-11-11'
SQL LITE does not support the data type DATETIME .
But in your Query you have to change the date format from 'dd-mm-yyyy' to 'yyyy-mm-dd'
this is the standard date format which is understand by SQL.
Refer the following link regarding SQL LITE Data types..
https://www.sqlite.org/datatype3.html[
^]