If you want to check until midnight today: SELECT * from request.events WHERE EventDate < #createDateTime(Year(Now()),Month(Now()),Day(Now()),11,59,59)#
Also, you might want to use <cfqueryparam> to pass in the value to SQL. On 5/23/07, Tom King <[EMAIL PROTECTED]> wrote: > > Hi All, > a quickie for someone hopefully? > > > I have the following SQL: > > > SELECT * from request.events WHERE EventDate < #Now()#; > > This returns all event before 'today'.. > > How would I do it to get all events including today? > > (a sort of Now + 1 day....?) > > Ta > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278962 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
