Question: I am trying to select data from a date range using `BETWEEN` in the where clause,But it does not return the correct result.The date field is in the format `'mm/dd/YYYY'` and the type is `varchar`
My query,

```
select * from time_track where track_date between '01/01/2015' and '01/21/2015'

```

But the result contain data with year 2014.

Can anyone please help me

Answer: 
I got the answer.

```
SELECT * FROM `time_track` where DATE_FORMAT(STR_TO_DATE(track_date, '%c/%d/%Y'), '%Y-%m-%d') between '2015-01-01' and '2015-01-21'

```
the format of your date is incorrect.
You must use this format in your query: yyyy-mm-dd.

select \* from time\_track where track\_date between '2015-01-01' and '2015-01-21'

Marco