Re: JD Edwards Dates

["Larry Ackerman" <xlore@xxxxxxxxx>]

The XYYJLN format is universal now, previously dates were stored as a mix
of four seperate fields and the julian format with a few stay MMDDYYs
thrown in.

World Writter, FASTR and STAR all do the conversion automatically behind
the scenes as does Showcase/Stratergy with the JDE add ins.

The callable conversion program is X0028 and there are copy members with a
simular names if you need to do the coversion a lot.

Standardizing the dates cleaned up the code even more than the files.


----------
> From: mcrump@ballfoster.com
> To: midrange-l@midrange.com
> Subject: JD Edwards Dates
> Date: Thursday, October 15, 1998 11:43 AM
> 
> 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
+---