|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.