The easiest solution would be to remove the time stamp of the compare.
On Tue, Apr 6, 2010 at 12:50 PM, Qing Xia <[email protected]> wrote: > > Hmm... thanks Brad and Mike for your quick replies. I have thought about > your answers deeply and decided they do make sense. :-) > > I read the CF Docs too quickly and made the assumption (never good to > assume!) that the CF dateDiff() function works the same way as the SQL > dateDiff() function, which says: "When the user tells me where to look, I > only look at that value." So a specified "d" means disregard the hour and > minute values, and just return the difference in days. > > Thanks again for your input! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

