Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date conversion

Status
Not open for further replies.
dataprincess

dataprincess

MIS
Apr 12, 2001
29
US
I'm trying to use Crystal Report Writer to create some reports off of JDE. Problem is that I can seem to convert their dates.

JDE Date = 110365 should convert to 12/31/2010
JDE Date = 100111 should convert to 4/20/2000

Can anyone help me? This obviously isn't your standard julian date and I'm too close to the trees right now.
 
Sort by date Sort by votes
This is the formula I use to convert JDE Julian dates:-

NumberVar Year1;
StringVar Date1;
NumberVar Cent1;

Date1 :=ToText({AS400.FIELDNAME}, "000000");
Cent1 :=ToNumber(Date1[1]);
Year1 :=If Cent1 = 0 then

(ToNumber(Date1[2 to 3]) + 1900)
Else if Cent1 = 1 then
(ToNumber(Date1[2 to 3]) + 2000);

(Date (Year1,01,01) + (ToNumber(Date1[4 to 6]) - 1));

If you wish to use the date in the data selection you will either have to use the JDE Julian date, link the julian date to the F00365 file or use a pick list.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mjstout
  • Locked
  • Question
Using calculations with the current date in World Writer
Replies
1
Views
263
jmd0252
jmd0252
mjs504
  • Locked
  • Question
Enterprise 8.10 Support Date
Replies
1
Views
145
jmd0252
jmd0252
infomania
  • Locked
  • Question
Date Conversion - Crystal Reports
Replies
0
Views
85
infomania
infomania
JDEdwardsCNC
  • Locked
  • Question
Conversion in JDE ERP 8.0
Replies
0
Views
73
JDEdwardsCNC
JDEdwardsCNC
triston
  • Locked
  • Question
DBCS to Unicode conversion
Replies
2
Views
104
triston
triston

Part and Inventory Search

Sponsor

Back
Top