Why does this SQLite query select all dates, even those outside of the criteria?

SQLite requires dates to be in YYYY-MM-DD format. Since the data in your database and the string in your query isn’t in that format, it is probably treating your “dates” as strings.