Date Math

[Jeff Harrison]

--- Jeff Harrison <jeffaharrison at yahoo.com> wrote:

> --- beppler at comcast.net wrote:
> 
> > Is there an easy way to get an elapsed time using
> > day & time?
> > 
> > Filepro v5.0
> > 
> > ie:  05/12/06 01:30:45  & 05/14/06 13:26:55  
> > 
> > I would like elapsed time in form HH:MM:SS
> > 
> > Thanks
> > Brandt>
> _______________________________________________
> 
> How about (date2-date1)*"24" < (time2 - time1)? 
> Just
> make sure that your date fields use a valid system
> date edit such as mdy/, and your time uses the
> "time"
> edit.
> 
> Jeff Harrison
> jeffaharrison at yahoo.com
> 

I guess you wanted one number for the hours though. 
In this case I would put the result of the time
calculation in a "hms" field, and then use the mid
function to extract the hours portion add add this to
the result of your date math * "24", then use mid
again to extract the minutes and seconds.  

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and imports.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com