Paul Rajs

Paul Rajs

  • NA
  • 641
  • 148.3k

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

May 6 2016 1:55 AM

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



Answers (6)