If this is MS SQL server you have the BETWEEN function. WHERE #now()# BETWEEN EventStartDate AND EventFinishDate
Wil Genovese Sr. Web Application Developer/ Systems Administrator Wil Genovese Consulting [email protected] www.trunkful.com On Jun 13, 2010, at 9:07 PM, Jim Eisenhauer wrote: > > 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:334523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
