Re: Query calc # days

["Booth Martin" <Booth@xxxxxxxxxxxx>]

This worked fine where START is a 6 digit numeric year.  For testing I
subtracted date2 (today's date) and got accurate answers.
 
Duration is years/months/days (Use F16 to put in the edit word)


DATE1       SUBSTR(DIGITS(START),1 ,2)||'/'|| 
            SUBSTR(DIGITS(START),3 ,2)||'/'|| 
            SUBSTR(DIGITS(START),5 ,2)        
                                              
DATE2       Current(DATE)                     
                                              
                                              
DURATION    Date2 - Date1                     
                                              
                                              
 
 
 
---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Monday, March 03, 2003 18:06:57
To: Midrange Systems Technical Discussion
Subject: Re: Query calc # days
 
Got the info in YYMMDD no century code. Yes, years are 00 for 2000, 02 
for 2002 etc. I also see some of the days did not calc correctly. What 
do you suggest?

Gail Crane
Johanson Manufacturing Corp.
phone 973-334-2676
gcrane@xxxxxxxxxxxxxxx




rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/03/2003 04:44 PM
Please respond to Midrange Systems Technical Discussion


To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc: 
Subject: Re: Query calc # days


Gail,

Do any of those dates have a digit other than 1 in the first position, 
and, have a year less than 40?

If so, you may have a problem with Richard's solution.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

.