I want to get the records between two particular Dates only . My Using Code isSELECT 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/201514/09/201514/09/201514/09/201515/09/201515/09/201515/09/201515/09/201515/09/201515/09/201518/09/201518/09/201518/09/201518/09/201512/10/201522/02/201607/10/2015If 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 youPaul.S