Question:
How do I write a statement that selects data between two dates?
Answer:
You can select data within two dates using the BETWEEN operator. Using the Orders table in the Northwind database, here’s a sample query:
SELECT OrderID, CustomerID, OrderDateFROM Northwind.dbo.OrdersWHERE OrderDate BETWEEN '7/1/96' AND '7/31/96'
The BETWEEN operator includes records where the criteria matches the BETWEEN values. So records with dates of 7/1/96 and 7/31/96 will be included. You can also use NOT BETWEEN to exclude data, like this:
SELECT OrderID, CustomerID, OrderDateFROM Northwind.dbo.OrdersWHERE OrderDate BETWEEN '7/1/96' AND '7/31/96'