Thanks
At 05:19 PM 9/26/2002 -0400, you wrote:
>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
