Julian Date Converter

JD Edwards files are often stored in the Julian format and this page offers an easy way to convert JDE dates to either Julian and Gregorian online without having to jump into excel and performs a number of steps. Simply enter your value and then click on “Lookup Julian” or “Lookup Gregorian” to convert the date.

JDE Julian Date Converter Online v1.1 - Convert CYYDDD to and from DD/MM/YYYY
JDE Julian Date Operation Simple Date

CYYDDD

DD/MM/YYYY
Multiple JDE Julian Dates Converter
JDE Julian Dates Operation Simple Dates





Converting JDE Julian Date to DD/MM/YYYY Format In Excel
  1. Place your JDE Julian Dates in Column A
  2. Suppose your first date is in Cell A1 and let's say that it is 113338
  3. Now, in cell B1 (or wherever you want the desired output), paste the following formula :
    =DATE(YEAR("01/01/"&TEXT(1900+INT(A1/1000),0)),MONTH("01/01/"&TEXT(1900+INT(A1/1000),0)),DAY("01/01/"&TEXT(1900+INT(A1/1000),0)))+MOD(A1,1000)-1
  4. Copy it here
  5. Do NOT forget to replace the cell address, incase your cell is different than A1
  6. If there are multiple dates in the column, just drag the cell to fill the column corresondingly
  7. Please note that by default the dates will be in MM/DD/YYYY format.
  8. In this example, the result obtained was : 12/4/2013
  9. If you want the output in DD/MM/YYYY format, right click on the cell > Format Cells... > Number (Tab) > Date
  10. Select Location as "English (United Kingdom)" and double click the appropriate "Type"
Converting DD/MM/YYYY Format to JDE Julian Date In Excel
  1. Convert your date from DD/MM/YYYY format to MM/DD/YYYY format
  2. Place your Dates (any format, but it must be parsed as a date) in Column A
  3. Suppose your first date is in Cell B1 and let's say that it is 12/04/2013 (4th Dec 2013)
  4. Now, in cell C1 (or wherever you want the desired output), paste the following formula :
    =(YEAR(B1)-2000+100)*1000+B1-DATE(YEAR(B1),"01","01")+1
  5. Copy it here
  6. Do NOT forget to replace the cell address, incase your cell is different than B1
  7. If there are multiple dates in the column, just drag the cell to fill the column corresondingly
  8. In this example, the result obtained was : 113338

RSS
LinkedIn
LinkedIn
Share