On 3/3/2010 1:29 PM, Michael Dinowitz wrote: > >> Anybody have ANY ideas whatsoever? I sure don't.... >>
To expand on Micheal's answer. You have to be careful of the datediff() result as it always rounds *DOWN*. Thus if you are asking for the difference in days between two date time objects that are 9 days, 23 hours and 59 minutes apart, the function will return a value of 9. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

