> Also, note that in SQL Server, the assumption is midnight,
> so that the end date is really the day before,
> so you could do this before your query:
>
> <cfset endDate = dateAdd("d", 1, form.someEndDate) />
Yes, though the safest option is using a >= and < comparison since BETWEEN is
inclusive.
<!--- omitted cfqueryparam for brevity --->
WHERE EventDate <= #startDate#
AND EventDate < #dayAfterTheFormEndDate#
-Leigh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329233
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
