DateDiff()? or maybe I misunderstood your question. Nick Han
>>> [EMAIL PROTECTED] 09/26/02 01:45PM >>> I have two date and time fields, start and end. I want find the difference and i want to display the difference as days:hrs:mins:secs what is the best way to do that... ? Right now i use hour minute and second (built in functions) and those work find for differences less than one day but they do not display the correct amount of hours for differences longer than 1 day... any suggestions <>< Proverbs 3:5 "Trust in the Lord with all your heart and lean not on your own understanding;" ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
