AlphaPress Publishing
P.O. Box 5942 Albany, NY 12205
Tel: 518-250-3890

Click to buy this book from Amazon

Section Menu 


Pindaro is now working on a comprehensive book on SQL Server 2014.  For any comments you can email the author at




How to use BETWEEN with the year() function

To contact the author click here

This article is from the book "Access 2007 Pure SQL

To download the sample database click here

The BETWEEN operator with the function

Find orders placed within a year range


In this example we use the year() function to extract the year out of the orderdate field so that we can use year values as the lower and upper boundaries.  All orders from 2009 and 2010 will be included in the result set due to the inclusivity characteristic of the BETWEEN operator. 


SELECT OrderID, orderdate, shippeddate

FROM orders

WHERE year(orderdate) BETWEEN 2009 AND 2010

ORDER BY orderdate DESC