|
I think there are a few concerns Check the math out on the cross century boundary calcs Next you get into multiple date conversions thus there could be a real performance concern with any sort of volume. There is a commercial standard date routines available that does this in -I think over 106 different formats including calc of date differences. day of week year etc, Regards, Glenn ________________________________________________ Glenn Ericson, Phoenix Consulting LLC P O Box 701164 East Elmhurst NY 11370-3164 USA Phone 718 898 9805 Fax 718 446 1150 AS/400 & Year 2000- - Solutions Specialists � copyright 1996 - 1999 all rights reserved ________________________________________________ At 09:26 AM 2/18/99 +1100, you wrote: >Glenn, > >Depending on the way in which you want the difference expressed, I would >suggest perhaps a CL program that accepts the two dates, does a CVTDAT to >Julian (on both dates), then subtracts one from the other. The difference >between the two dates would then be the number of days. > >Regards, > >Rick Renkema >AS/400 Development Manager >Create!print International >Phone: +61 (3) 9824 6888 >Fax: +61 (3) 9824 6866 >Mobile: +61 (0) 412 CPRINT (277 468) >E-mail: rick@createprint.com.au > >"All great discoveries are made by mistake." > >-----Original Message----- >From: Glenn-Cons.T.Geathers@am.pnu.com >[SMTP:Glenn-Cons.T.Geathers@am.pnu.com] >Sent: Thursday, 18 February 1999 03:40 >To: MIDRANGE-L@midrange.com >Subject: date difference > >Does anyone have a routine for dates that will give the difference between >two dates. The one we have with the robot product isn't working & we need >the routine yesterday. Private replies would be appreciated. Regards, >Glenn. >z9gtgeat@am.pnu.com >+--- >| This is the Midrange System Mailing List! >| To submit a new message, send your mail to MIDRANGE-L@midrange.com. >| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. >| To unsubscribe from this list send email to >MIDRANGE-L-UNSUB@midrange.com. >| Questions should be directed to the list owner/operator: >david@midrange.com >+--- > >+--- >| This is the Midrange System Mailing List! >| To submit a new message, send your mail to MIDRANGE-L@midrange.com. >| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. >| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. >| Questions should be directed to the list owner/operator: david@midrange.com >+--- > +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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 copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.