DateDiff(datepart, date1, date2)
> -----Original Message----- > From: John Gedeon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 26, 2002 3:45 PM > To: CF-Talk > Subject: Time calculation > > 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
