lorser98
Member
Re: Converting JDE Julian Dates into something more readable .
I entered this formula but keep getting an error on "&1t". What does this
represent?
Thanks
Lori Orser
Senior Programmer/Analyst
Cookson Electronics PWB Materials and Chemistry
email: [email protected]
sbrown
<sbrown@dixonusa To: [email protected]
.com> cc:
Sent by: Subject: Re: Converting JDE Julian Dates into
owner-jdeworld@j something more readable .
delist.com
06/11/02 08:13
AM
Please respond
to jdeworld
you can use the following formula in excel to convert the date after you
have downloaded it into excel'
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))
--------------------------
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=35945
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World? mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com
JDEList is not affiliated with JDEdwards®
+ - - - - - - - - - - - - - - - - - - - - - - - -+
I entered this formula but keep getting an error on "&1t". What does this
represent?
Thanks
Lori Orser
Senior Programmer/Analyst
Cookson Electronics PWB Materials and Chemistry
email: [email protected]
sbrown
<sbrown@dixonusa To: [email protected]
.com> cc:
Sent by: Subject: Re: Converting JDE Julian Dates into
owner-jdeworld@j something more readable .
delist.com
06/11/02 08:13
AM
Please respond
to jdeworld
you can use the following formula in excel to convert the date after you
have downloaded it into excel'
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))
--------------------------
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=35945
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World? mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com
JDEList is not affiliated with JDEdwards®
+ - - - - - - - - - - - - - - - - - - - - - - - -+