Using between to compare datetimes is a didatic concept and this practice isn't optimazed.

May this article help you.

http://databases.aspfaq.com/general/should-i-use-between-in-my-database-queries.html