Like Mark said, I'd first look to using the year() function if its available in your dbms.If not you can also use a BETWEEN.
i.e. where createdDate BETWEEN createODBCDateTime(startdate) AND createODBCDateTime(enddate) Another option I guess (I think depending on dmbs as well) is to use the >= and <= similar to the BETWEEN above. All of them will get you what you want, we could probably argue for days over which is better I guess! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
