> I was thinking that the function could function when the arguments are > essentially the same day.
I'm a little confused. The dateDiff() function DOES work when the arguments are the same day. Have we led you to believe otherwise, or are you talking about a different "function" functioning? > Here's what I did to solve the problem: when the function returns 0, do this: Exactly what combination of inputs to dateDiff() is returning zero? If it is your second example in your original post, then it SHOULD return zero because the two dates were less than one minute apart. Your code below is asking whether or not the two times are in the same "hour" and "minute" which is a different question than asking how many full hours and minutes exists between the times. (It's also worth noting your code below will ONLY work for times on the same day and with a 24 hour clock) If your objective is to decide if the times are in the same "minute" then you should probably always be using datePart() starting with the largest unit (year) and working in and NOT using dateDiff() at all. Alternatively you could continue to use dateDiff() to the second level, divide by 60, and "ceiling()" the result up to the next full minute which is essentially what you are doing below. Perhaps you can explain exactly what you were trying to do. ~Brad <cfoutput> <cfset holdTotalHours = ABS(DatePart("h", arguments.HighDate) - DatePart("h", arguments.LowDate))> <cfset holdTotalMinutes = ABS(DatePart("n", arguments.HighDate) - DatePart("n", arguments.LowDate)) Results in (HH:MM) Format: #holdTotalHours#:#holdTotalMinutes# </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm