Are they against letting you add a real date field? I've been there, in spades, and there's always a way through. Sometimes it's a lot easier, and not as much fun, as banging your head against the same angle of attack for hours tho. :-)
Perhaps add a date field, and then make some magic that turns those integers into dates. And THEN do the query. Not as cool as one fell swoop (although if you're good at your SQL dialect, crazy queries like that ARE possible), but still. force be with you, :denny On Mon, Mar 24, 2008 at 6:07 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > Claude Schneegans wrote: > > How about: > > and YEAR >= #form.from_y# and YEAR <= #form.to_y# > > and ((MONTH >= #form.from_m# and MONTH <= #form.to_m#) OR MONTH=0) > > and ((DAY >= #form.from_d# and DAY <= #form.to_d#) OR DAY=0) > > The problem with that is the same problem as the previous example I > posted though. > > Try searching for dates between 10/15/2006 and 04/14/2007 > > See the problem? > > > Yup, I've scr*wed myself on this one I believe! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
