RE: date difference

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
+---