# JD Edwards Julian Date Converter (CYYDDD)

> Source: https://netray.co/tools/jde-julian-date-converter-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Turn a calendar date into the CYYDDD Julian number JDE stores in tables such as F0911 and F4801, with leap years handled.

## Category

oracle

## Erp

Oracle JD Edwards EnterpriseOne

## Audience

- JDE developer
- Report writer
- JDE functional consultant

## Tool

**Kind:** calculator

**Inputs:**

#### Year

**Key:** year

**Type:** number

**Default:** 2026

**Min:** 1900

**Max:** 2099

**Step:** 1

#### Month

**Key:** month_offset

**Type:** select

**Default:** 273

**Options:**

##### January

**Value:** 0

##### February

**Value:** 31

##### March

**Value:** 59

##### April

**Value:** 90

##### May

**Value:** 120

##### June

**Value:** 151

##### July

**Value:** 181

##### August

**Value:** 212

##### September

**Value:** 243

##### October

**Value:** 273

##### November

**Value:** 304

##### December

**Value:** 334

**Help:** The value is the number of days in the months before the chosen one in a non-leap year.

#### Day of month

**Key:** day

**Type:** number

**Default:** 19

**Min:** 1

**Max:** 31

**Step:** 1

**Outputs:**

#### Leap year (1 = yes)

**Key:** is_leap

**Expr:** if(and(eq(year - 4 * floor(year / 4), 0), or(not(eq(year - 100 * floor(year / 100), 0)), eq(year - 400 * floor(year / 400), 0))), 1, 0)

**Format:** text

#### Day of year

**Key:** doy

**Expr:** month_offset + day + if(gt(month_offset, 31), is_leap, 0)

**Format:** text

#### CYY (years since 1900)

**Key:** cyy

**Expr:** year - 1900

**Format:** text

**Description:** The first three digits of the JDE date.

#### JDE Julian date (CYYDDD)

**Key:** julian

**Expr:** (year - 1900) * 1000 + doy

**Format:** text

**Primary:** true

**Description:** The value stored in date columns such as GLDGJ or WASTRT.

**Disclaimer:** Check the day against the month length yourself, for example 31 April is not rejected. JDE date columns of 0 mean no date.

## Content

**Intro:** JD Edwards EnterpriseOne keeps dates in its database as a six digit Julian number called CYYDDD. This converter turns a calendar date into that number and shows how to turn it back to a real date in SQL.

**Sections:**

#### How to use it

**Body:** Pick the year, month and day. The result is the value you can paste into a WHERE clause against columns such as GLDGJ (GL date) in F0911 or WADRQJ (request date) in F4801. For example 19 October 2026 is day 292 of the year, giving 126292.

#### The CYYDDD structure

**Body:** C is the century indicator, calculated as the year divided by 100 minus 19, so 0 for 1900 to 1999 and 1 for 2000 to 2099. YY is the last two digits of the year and DDD is the day of the year from 001 to 366. Put together it equals (year minus 1900) times 1000 plus the day of year, which is the formula this calculator uses.

**Bullets:**

- 1 January 2000 is 100001
- 31 December 1999 is 099365
- A stored value of 0 means no date

#### Decoding in SQL

**Body:** In SQL Server use DATEADD(DAY, (col % 1000) - 1, DATEFROMPARTS(1900 + col / 1000, 1, 1)). In Oracle use TO_DATE(TO_CHAR(1900 + TRUNC(col / 1000)) || LPAD(MOD(col, 1000), 3, '0'), 'YYYYDDD'). In DB2 for i, the DATE function with the Julian format works similarly. Guard against zero values with a CASE expression.

#### Common mistakes

**Body:** Forgetting that the century digit changed at 2000, comparing a Julian number to a formatted date string, and using BETWEEN on dates that span a year end without considering both years. Leap years add a day after February, which this tool handles.

**Cta:** If you routinely translate JDE dates and amounts for reports, we can build read-only reporting views or a query assistant that does it for you.

**Faq:**

#### What is the JDE date 126001?

**Answer:** It is 1 January 2026. The 126 is 2026 minus 1900 and the 001 is the first day of the year. Likewise 126365 is 31 December 2026 because 2026 is not a leap year.

#### Why is there a century digit?

**Answer:** JD Edwards designed the format around the year 2000 problem. The century digit allows years from 1900 to 2899 in six digits while staying compatible with older two digit year data.

#### Can I change the JDE date format in the database?

**Answer:** No. The stored Julian format is part of the data dictionary type JDEDATE. Applications convert it to your user display format. Report writers must convert it themselves in SQL.

#### How are times stored?

**Answer:** Time columns such as the update time are usually six digit integers in HHMMSS form, for example 143005 for 14:30:05. They are separate from the date column.

## Search terms

jde julian date converter, jd edwards julian date, cyyddd date format, convert jde date to sql date, jde date format 126, jd edwards date in database, julian date calculator jde

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json