>>BETWEEN '10/01/2010' AND '02/01/2011' >>The data type for dateWorked in varchar.
You cannot use this date format in a text field if you need to sort it or compare ranges. You need to use at least some "yyyy mm dd" format or better a true date format in the database. In your example '10/01/2010' is alphabetically greater than '02/01/2011' although it is chronologically before, and there cannot be nothing in between. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3380 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
