6

December 22, 2009 in Blog, Dynamics AX by Amer

Hijri date in Dynamics AX

In Microsoft Dynamics AX 2009, Hirji calendar (the Islamic calendar) is not yet supported although Hirji date is there in the background of Dynamics AX 2009!

To enable the Hirji Calendar, you should modify some X++ code in the User Options form. To do so, go to: SysUserSetup –> Methods –> run and change the following blue code into the red:

Enabeling Hijri Calendar in User Options form in X++

  

  By doing this, you will have a drop down list in the User Options shown in the General tab like the following:

Hijri date in User Options form

With this options, you could clearly understand that Microsoft is putting something to enable the Hijri calendar. I have done some testing over this options. It looks that they’re using a middleware to convert the “actual” Gregorian date that is in the database so the user see the data in Hijri format. Unfortunately, I couldn’t complete the testing with successful results… it started to get me weird results. That’s why Microsoft is not yet supporting it.

  

Till Microsoft supports it, you could use a very easy to use function in the SQL server: convert(datetime,’12-22-2009′,102), 131)  

  

To solve the Hirji date problem, you could create a class with two methods:  

 

1. One that takes a “date”  and returns a Hirji date after calling this SQL method: select convert(varchar,convert(datetime,’12-22-2009′,102), 131)  –try to run this in SQL Server to see the result. 
2. Other that takes a Hijri date in an str format, and returns a date by executing this SQL code:  select convert(datetime,’22-01-1417′, 131) –try to run this in SQL Server to see the result

 By this, you could have the ability to show the user a StringEdit control that uses edit moeth to write a Hirji date and you save the result of conversion in the normal Gregorian date, like this:

Edit method to show Hirji date from Gregorian date

This is the result:

Hiji StringEdit control and DateEdit control

 

Share this article:

6 Comments to “Hijri date in Dynamics AX”

• Dynamics User
  January 18, 2010 at 12:56 pm

  Hi,
  Thanks a lot for the post, really helpful…
  but for the class to be created, how can the SQL command be written in AX Code?

  Thanks

  Reply
• Amer
  January 18, 2010 at 11:22 pm

  Hi!

  Try this code. This function basically takes a “normal” date as a parameter and returns the converted Hijri date as a string.

  server static str convertDateToStr(date strDate)
  {
  DictTable _dictTable;
  Connection _connection;
  Statement _statement;
  str _sql,strResultDate;
  ResultSet _resultSet;
  Enumerator enum, enum2;
  SqlStatementExecutePermission _perm;
  Str _tempStr;
  ;

  _tempStr = int2str(mthofyr(strDate)) + “-” + int2str(dayofmth(strDate)) + “-” + int2str(year(strDate));

  _Sql= “select convert(varchar,convert(datetime,’” + _tempStr + “‘,102), 131)” ;

  _connection = new Connection();

  _perm = new SqlStatementExecutePermission(_sql);

  // Check for permission to use the _statement.
  _perm.assert();
  _statement = _connection.createStatement();
  _resultSet = _statement.executeQuery(_sql);

  // End the scope of the assert call.
  CodeAccessPermission::revertAssert();

  _resultSet.next();

  strResultDate = _resultSet.getString(1);
  strResultDate = strLrTrim(strResultDate);
  enum = strSplit(strResultDate,” “).getEnumerator();

  if(enum.moveNext())
  strResultDate = enum.current( );

  enum2 = strsplit(strResultDate, “/”).getEnumerator();
  if(enum2.moveNext())
  {
  if(any2int(enum2.current()) < 10)
  strResultDate = “0″ + strResultDate;
  }

  return strResultDate;
  }

  Reply
• Microsoft Dynamics AX Thoughts » Yet another great way to handle the Hijri date in Dynamics AX!
  May 15, 2010 at 11:38 pm

  [...] a previous post, I descriped in deatils how to gte (and set) Hijri date in Microsoft Dynamics AX 2009. In that post [...]

  Reply
• Microsoft Dynamics AX Thoughts » Convert All Hirji Formats into Gregorian
  October 5, 2010 at 11:50 am

  [...] Hijri date in Dynamics AX [...]

  Reply
• Mb
  February 20, 2011 at 10:37 am

  thanks for your great posts
  Where we should write this edit method?

  Reply
• Amer
  February 20, 2011 at 12:45 pm

  HI Mb:),

  In the form you want this field to be displayed in.

  Reply

Dynamics AX 2012 Event

Recent Posts

Tags

Archives

Random Testimonial

What's the little bird saying?