This is one way of doing it. But watch out. Got bit by some old code that used this approach on the switch to daylight savings time. It's better to add a day, then subtract a second.
> 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
