Penny dropped - thank you!!!!!!!!! I was over complicating it.
++++++++++ Kevin Parker m: 0418 815 527 ++++++++++ http://au.linkedin.com/in/krparker -----Original Message----- From: Roger Austin [mailto:[email protected]] Sent: Monday, 14 June 2010 11:42 To: cf-talk Subject: Re: Date range with a date in the past On 6/13/2010 9:30 PM, Kevin Parker wrote: > > Greatly appreciate another set of eyes looking at this please. > > Picking events from a table based on dates so that only current or future > events show up. Date values can not be NULL. > > (EventStartDate>= #now()#) AND (EventFinishDate>= #now()#) > > Let's say an event runs from 17/6 to 19/6 things work OK today but on the > 18/6 this event will drop off the calendar even though it's still running. > > Greatly appreciate any insight - TIA!!!! Why do you have the first condition? Anyway, wouldn't this be an OR? -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) NCDevCon: http://ncdevcon.com/ 2010 Raleigh ColdFusion Conference ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
