Re: substract DATE variables
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1996/10/04
Message-ID: <32553AA1.23E6_at_charlie.cns.iit.edu>#1/1
Date: 1996/10/04
Message-ID: <32553AA1.23E6_at_charlie.cns.iit.edu>#1/1
Eric Pronovost wrote:
>
> I have a table with the following fields:
>
> No_Item Number(5)
> Time_Began Date
> Time_Done Date
>
> I would like to get the time it takes, in average, to build an item. I need
> it to be in minutes and seconds. However, I'm not able to substract 2 date
> variables.
>
> How can it be done?
>
> Thanks!
>
> Eric Pronovost
> epronovo_at_mail.odyssee.net
For Example If want to subtract date1 and date2
do (date1)-(date2) gives value in days
IF you want the value in min. multilpy the above value with 24*60;
(DATE1) - (DATE2) =DATE X (IN DAYS)
HOPE THIS HELPS
AMARENDRA B NETTEM
WHITTMAN-HART, CHICAGO
Received on Fri Oct 04 1996 - 00:00:00 CEST