Well that would only work IF your dates are stord in that format.....but even then it's a bit weak.
The real solution is to change the dates to dates ;-) Cheers On Fri, 2011-02-11 at 12:52 -0500, Torrent Girl wrote: > That didn't work either. > > > > >Try > > > >SELECT * FROM agentdaily where dateWorked BETWEEN '2010-10-01' AND > >'2011-02-01' > > > > > > > > > >On 2/11/2011 11:38 AM, Torrent Girl wrote: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3385 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
