How to select data between two dates?

  • Thread starter Thread starter xyfix
  • Start date Start date
X

xyfix

Hi... anyone can help me to figure out how to select a data between 2
date. i.e. i use 1 table : SALE(date_sale,quantity,amount,sale_no). I
want to select all data from sale between 2.2.2004 and 15.2.2004. Is it
works like this : SELECT * FROM SALE WHERE SALE_DATE BETWEEN "2/2/2004"
AND "2/15/2004" ? Please help and give me guidance. Thank you
 
Actually, I think you want this:

SELECT * FROM SALE WHERE SALE_DATE BETWEEN #2/2/2004# AND #2/15/2004#

Good Luck
 
Back
Top