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)