Re: JD Edwards Dates

You find the julian dates easier to work with than:
C     LOANDATE      ADDDUR    XX:*YEARS     DUEDATE              
C     DUEDATE       SUBDUR    XX:*YEARS     LOANDATE             
C     LOANDATE      SUBDUR    DUEDATE       LOANDAYS:*DAYS    5 0
I'm surprised.

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/QB3AGZ00/4.3.8?ACTION=MATCHES&REQUEST=DATE+OPERATIONS&TYPE=FUZZY&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK#FIRSTHIT





cgalgano@ediconsulting.com on 10/15/98 01:03:49 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      

Subject:        Re: JD Edwards Dates

There is a server program , I think it is X0028 to convert the dates between
the different formats.  I have found the julian dates easy to work with and
they are much better suited for doing date arithmetic.
Carl Galgano
EDI Consulting Services, Inc.
http://cgalgano.home.mindspring.com
mailto://cgalgano@ediconsulting.com
(770) 422-2995

-----Original Message-----
From: mcrump@ballfoster.com <mcrump@ballfoster.com>
To: midrange-l@midrange.com <midrange-l@midrange.com>
Date: Thursday, October 15, 1998 1:01 PM
Subject: JD Edwards Dates


|Somewhere along the line I must not be living right because I seem to be
|paying for it now...
|
|We are in the process of upgrading from JDE A6.2 to A7.3.  We just came
|across the documentation for date storage.  Historically, JDE has stored
|stuff in Gregorian format in four seperate fields DD, MM, CC, and YY.
|
|Now in 7.3 all dates are being changed to 'Julian'.  The format is XYYJLN
|where X is a centery flag(0 = 19, 1 = 20), YY is year, and JLN is the
|Julian day within a year.
|
|According to their documentation, and I quote, 'Julian date processing
|allows for the use of a single field, eases manipulation, sorting, and
|calculation of dates'.
|
|I'm real frustrated because we have to change a lot of access points.
|Multiple systems, DDM files, modifications, and query tools.  Am I missing
|the boat or does this change make sense.......besides benefiting JDE?
|
|Respectfully but pretty ______ off,
|
|Mike
|
|
|+---
|| 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
+---