Date Conversion w/Cognos

[skippaNH]

Does anyone know of a way to change a SQL View of JDE data to translate their date in to a normal date format i.e. 09/05/01. The JDE "date" format isn't stored in SQL as a date, but as a numeric field, 9 digits

JDE Format:

CYYddd

C - Century
YY - YY
Ddd - day of year

So:
Century - 0 = 1900
Century - 1 = 2000
YY = 01, 02, 67, 95, etc.
DDD = 1-365 to represent the day.


We are trying to find the best way to convert it in order to pull it into Cognos Impromptu.

 

[Guest_imported]

J.D. Edwards stores dates in Julian format. Rather than trying to translate and store the converted Gregorian date in JDE, simply use an Impromptu Julian-to-Date function. I can provide it to you. Send an email to me at:

gsteffine@JGLP.com

Greg Steffine
Senior BI Consultant
Certified Cognos Developer
JeremiahGroup, L.P.
724.857.3353

JeremiahGroup. Empowering you to make better decisions.(TM)