RE: date difference

[Rick Renkema <rick@xxxxxxxxxxxxxxxxxx>]

Booth,

You are, of course absolutely correct ... :)

I read the "we needed it yesterday" and did not take Y2K into consideration.  
Apologies.

By the way, I believe *JUL would return 00001 and 99365.  *LONGJUL would return 
2000001 and 1999365. 

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:   boothm@ibm.net [SMTP:boothm@ibm.net]
Sent:   Thursday, 18 February 1999 12:49
To:     MIDRANGE-L@midrange.com
Subject:        RE: date difference

I'm not sure it works quite that way.  20000101 sub 1999365 is not 1. 


>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.
-- 
-----------------------------------------------------------
boothm@ibm.net
Booth Martin
-----------------------------------------------------------

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