Re: Query calc # days

[rob@xxxxxxxxx]

Originally you said "actually stored in file as CMMDDYY".  That had me 
concerned.  So which format is it - CMMDDYY or YYMMDD?

Do you have a sample of what days were wrong?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




gcrane@xxxxxxxxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/03/2003 05:47 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        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.