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