Julian Date Conversion CYYDDD

allysonjones12

Member
I am given a gregorian date and need to convert it to julian date CYYDDD or 1yyddd for year 2000. I have been able to convert the date to yyyyddd with the formula:
JD = Day + (153*Mo+2)/5 + Yr*365 + Yr/4 - Yr/100 + Yr/400 - 32045;


I can only use simple math functions--no sql or C++ etc..
Does anyone have a formula for 1yyddd?
 
Add 1900000 value to it and use *longjul date function.
Here is an opposite for what you are doing:

ISODate =3D Úte(JDEdate + 1900000:*longjul)

From: [email protected] [mailto:[email protected]] On Behalf Of allysonjones12
Sent: Thursday, November 05, 2009 1:59 PM
To: [email protected]
Subject: Julian Date Conversion CYYDDD

I am given a gregorian date and need to convert it to julian date CYYDDD or 1yyddd for year 2000. I have been able to convert the date to yyyyddd with the formula:
JD =3D Day + (153*Mo+2)/5 + Yr*365 + Yr/4 - Yr/100 + Yr/400 - 32045;


I can only use simple math functions--no sql or C++ etc..
Does anyone have a formula for 1yyddd?
 
Check out X0028 -- I am guessing all JDE versions would have access to this standard routine. Not ILE but it works either way Julian or Gregorian.

Good Luck,

Fred Short
Corporate Systems Support
(501) 748-5885
 
Back
Top