Date Math

Jeff Harrison jeffaharrison at yahoo.com
Tue May 16 03:36:43 PDT 2006


--- 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

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 


More information about the Filepro-list mailing list