WHERE EventStartDate>= #now()# AND EventFinishDate<= #now()# You had your end date looking for a date ">=" Now()
Jim Eisenhauer On Sun, Jun 13, 2010 at 6:41 PM, Roger Austin <[email protected]> wrote: > > 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:334521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
