RE: JD Edwards Dates

[Cyndi Bradberry <CyndiB@xxxxxxxx>]

Mike,

We know what you mean. We upgraded to JDE 7.3 last year.  After putting it
into production, the accounting department came back screaming that their
reports (queries) looked strange and couldn't possibly be pulling the
correct data.

Unfortunately, the JDE programmer was out for a few days, and I had to try
and figure it out. They did not appreciate my suggestion of figuring out the
Julian date to put in the date selection !

Needless to say, our JDE programmer has spent a bit of time rewriting
queries into JDE World Writers. They handle the date conversion behind the
scenes.  But definitely a big pain to deal with. I would have rather had
CCYYMMDD than Julian.

Cyndi Bradberry
Idaho Housing and Finance Association
Boise, Idaho

-----Original Message-----
From: mcrump@ballfoster.com [mailto:mcrump@ballfoster.com]
Sent: Thursday, October 15, 1998 9:44 AM
To: midrange-l@midrange.com
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
+---