Date Math

beppler at comcast.net beppler at comcast.net
Tue May 16 05:55:36 PDT 2006


The "Time" edit will not allow any number greater then 23 in the Hours slot.

-------------- Original message -------------- 
From: Jeff Harrison <jeffaharrison at yahoo.com> 

> --- Jeff Harrison 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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060516/64af53e8/attachment.html


More information about the Filepro-list mailing list