Create SQLite queries for records within a specified date range 

Using SQLite version 3.5.1. SQLite query for selecting all records between a certain date range. 'created_at' in this example is the column heading. Query only worked when the 'Y' was upper case and the 'm' and 'd' were both lower case.