Hijri Date

Hello There,

I know that JD Edwards dose not support the Islamic date (Hijri Date). So, I am looking for suggestions of the applicable workarounds to do that.

Thanks
Anan
Technical Sales Manager
B73.1.1 through E900
DB2/400, Oracle, SQL Server
AS/400, Windows, Citrix, OAS/WebLogic, WebSphere, VMWare

Grab a JDE developer that knows a little web programming and have them build a custom function…

Here is a JavaScript example you can simulate: http://www.oriold.uzh.ch/static/hegira.html (You can View Source from your browser)

I don’t know anything about Hijri dates but looks like It’s been done in various other languages and applets. I would also confirm the code you are replicating works correctly.

3anan,

That might be an interesting test of fun - to append that type of functionality.

Conceptually - I don't think the actual logic would be so hard, but the busy-work of identifying everyplace you want the Hijiri dates to display would be a bit more work.

I'm going to research this a bit - but, the others on the list can help by appending input/suggestions...

Questions/Suggestions:
1 - Do the dates have to be Searchable or Sequenced?
a - if No, simplicity is to create a function that converts the JDE Date to Lunar Date (I'm sure we can find that logic, somewhere?)
b - if Yes, plug the Lunar Date logic into an SQL View over any required table. Then the Hijiri date can be searchable via the BSVW. I saw some Oracle Code - we might be able to hijack.

2 - Do you want to update the Date Value, or just view and report on it?
a - if No Update - logic is simplified
b - if Yes Update - convert the Hijiri date back into JDE and update the JDE Value

Do you have a couple tables/screens/reports you would like to use as Proof of Concept?

JDE Research can document, if a good example is determined.

(db)

3anan,

I can see why the bOrGacle has decided 'not' to include Hijiri Dates computations - YUCK!

From Wiki -
Hijiri Dates
=====
To convert from a Hijri year to a Gregorian year:
G = 0.97023×H + 621.57
To convert from a Gregorian year to a Hijri year:
H = (G − 621.57)/0.97023
======

Wiki doesn't really clarify the what the actual value of 621.57 and .97023 really represtent (years, Dates, Hours???). I don't have time to play with it....

Now, scanning through a ton of dialogs under the SQL Server and Oracle/PL/SQL locations - it looks like your cleanest solution might be to create an SQL View

Both Oracle and MS SQL databases have the ability convert a System or Gregorian date to Hijiri. I didn't find any clarity regarding iSeries. With that knowledge, you could create an SQL View over specified tables that do that conversion on the fly within the SQL View (convert JDE Date to Gregorian to Hijiri). You may have to build a Custom Data Dictionary entry to properly format the output on the screen/pdf.

Conceptually, there are several ways to provide the Hijiri date. From the E1 Tools side, unless Oracle provides us something better - I would suggest trying to convert the date via the Database and not trying to calculate it 'mechanically'.

The Hijiri Conversion is probably a bit more than I can complete for free.

If someone comes across a solution - I'm interested, too.


============================================
For notes, some of the syntax is similar to:
- Oracle:
http://www.orafaq.com/forum/t/166725/0/
http://www.orafaq.com/forum/t/142930/0/
- SQL Server:
http://www.sqlservercentral.com/Forums/Topic1007555-391-1.aspx
http://think-sql.blogspot.com/2009/09/working-with-hijri-date-in-sql-server.html

Enjoy!

(db)