Where Clause

Question

I want to use a WHERE CLAUSE with the AND operator to find dates between 2015-03-01 and 2015-03-31 in a column. This is the line i am using but it returns nothing and I know there is data matchiung. WHERE Slot = 2 and ExpiratinoDate > 2015-03-01 and < 2015-03-31                     What is wrong with that statement







Answer 1

How ExpiratinoDate is stored in your table? What is the data type? It's date or varchar or something else?

Could you provide sample dates that exists in your table?

---

-Vaibhav Chaudhari

Answer 2

WHERE ExpirationDate BETWEEN '2015-03-01' AND '2015-03-31'

WHERE ExpirationDate >= '2015-03-01' AND ExpirationDate <= '2015-03-31'

Answer 3

first you should check  datatype if it's right then try to use between clause on date function.

ExpiratinoDate  between 2015-03-01  and 2015-03-31