How To Get Records Between Two Particular(from-two) Dates

Question

I want to get the records between two particular Dates only .

My Using Code is
SELECT reportingdate FROM tbl_instrumentssales WHERE reportingdate >= '07/10/2015'
AND reportingdate<= '22/10/2015'

my code is working fine But it give output someother records Also instead of my reqirement.like below

14/09/2015,
14/09/2015
14/09/2015
14/09/2015
14/09/2015
15/09/2015
15/09/2015
15/09/2015
15/09/2015
15/09/2015
15/09/2015
18/09/2015
18/09/2015
18/09/2015
18/09/2015
12/10/2015
22/02/2016
07/10/2015

If i make any mistake in my query or i have to change anything na please tell me.
else give some example query for i am get records between two dates.
two dates is equal to From date & todate.

Thanking you
Paul.S

Nikhil Sangani · Answer

Try SELECT reportingdate FROM tbl_instrumentssales WHERE CONVERT(DATEreportingdate) between CONVERT(DATE'2015/10/07') and CONVERT(DATE'2015/10/22')

Munesh Sharma · Answer

http://www.plus2net.com/sql_tutorial/between-date.php

Shakti Singh Dulawat · Answer

Do you have times associated with your dates?

Paul Rajs · Answer

Thanks mr.Shakjti. Your code is correct but cant able to get exact output. i have to do anything else in my query..? My query SELECT reportingdate FROM tbl_instrumentssales WHERE reportingdate between '07/10/2015' and '22/10/2015' My Output 13/08/2015 12/08/2015 21/08/2015 15/09/2015 15/10/2015 16/12/2015 08/09/2015 08/09/2015 08/09/2015 08/09/2015 10/09/2015 10/09/2015

Bhuvanesh Mohankumar · Answer

Use BETWEEN keyword SELECT Date from sample WHERE Date BETWEEN '2011/02/25' AND '2011/02/27' Note: The Date value should be similar formatof how its stored in your database better I suggest to copy the sample date in database table and check the query. Mark as answer if found helpful.

Shakti Singh Dulawat · Answer

Try SELECT reportingdate FROM tbl_instrumentssales WHERE reportingdate between '2015/10/07' and '2015/10/22'