Microsoft Dynamics AX Blog
I came across a requirement where I needed to convert users entry from Hirjri Calendar date (the Islamic Calendar) into the Gregorian Calendar. In previous posts, I have shown how to convert Gregorian Date (date data type in Dynamics AX) into Hirjri… if you are interested in those check them out here:
In order to convert a Hirji date into Gregorian, I used the .NET classes referenced in the any Dynamics AX standard version.
Enjoy!
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | //Amer Atiyah, http://blog.amerax.net static date hijri2GrDate(DAPHijridateStr hijriDateStr) { System.Globalization.CultureInfo arCul = new System.Globalization.CultureInfo("ar-SA"); System.Globalization.CultureInfo enCul = new System.Globalization.CultureInfo("en-US"); System.DateTime tempDateTime; str strTemp; System.String[] arr; date grDate; ; //all expected dates formats arr = new System.String[18](); arr.SetValue("dd M yyyy", 0); arr.SetValue("yyyy/MM/dd", 1); arr.SetValue("yyyy/M/d", 2); arr.SetValue("d/M/yyyy", 3); arr.SetValue("dd/MM/yyyy", 4); arr.SetValue("yyyy-MM-dd", 5); arr.SetValue("d/MM/yyyy", 6); arr.SetValue("dd/M/yyyy", 7); arr.SetValue("yyyy-M-d", 8); arr.SetValue("dd-MM-yyyy", 9); arr.SetValue("yyyy MM dd", 10); arr.SetValue("d-M-yyyy", 11); arr.SetValue("d-MM-yyyy", 12); arr.SetValue("dd-M-yyyy", 13); arr.SetValue("d M yyyy", 14); arr.SetValue("dd MM yyyy", 15); arr.SetValue("yyyy M d", 16); arr.SetValue("d MM yyyy", 17); try { tempDateTime = System.DateTime::ParseExact(hijriDateStr, arr, arCul, System.Globalization.DateTimeStyles::AllowWhiteSpaces); } catch { error("Unexpected Hirji date format."); return datenull(); } strTemp = tempDateTime.ToString("dd/MM/yyyy"); grDate = str2date(strTemp, 123); return grDate; } |
It might a great idea if you added this method to the “Global” class, like what I did :).
Search the site
Dynamics AX 2012 Event
Recent Posts
- D365FO | Cannot Connect to SQL Server Database on Your Cloud Test Machines
- Intro to Microsoft Dynamics AX in Arabic – سلسلة حلقات مايكروسوفت داينامكس إيه إكس بالعربية
- Microsoft Dynamics Launch – Sunday, 24th February – Intercontinental Hotel, Riyadh
- Files of Our AX Brains Dec 2012 Event
- It was a great day!
- Tomorrow is the day for our Dynamics AX Brains Technical Seminar
- Dynamics AX Brains December 2012 Technical Seminar
- Windows Server 2012: Built from the Cloud Up
Tags
Archives
- October 2019 (1)
- January 2014 (1)
- February 2013 (1)
- December 2012 (4)
- September 2012 (2)
- December 2011 (2)
- November 2011 (3)
- July 2011 (3)
- June 2011 (4)
- May 2011 (3)
- April 2011 (4)
- March 2011 (12)
- February 2011 (2)
- January 2011 (3)
- December 2010 (1)
- November 2010 (1)
- October 2010 (5)
- August 2010 (1)
- July 2010 (3)
- June 2010 (4)
- May 2010 (5)
- April 2010 (1)
- March 2010 (9)
- February 2010 (4)
- January 2010 (4)
- December 2009 (11)
- September 2009 (1)
- August 2009 (1)
- July 2009 (2)
- September 2008 (1)
Random Testimonial
- ~ Ehab Elmetwally, ERP Business Unit Manager at Alfanar IT
"I worked with and managed amer for nearly 1 year and a half. A real technical consultant with tangable expierience. His capabilities and attitude enabled him to be of a big benefit to our departement. I recommend him as a professional technical consultant"
- Read more testimonials »
Hi Amer Atiyah,
This code is Working good, but i need to find the Last Day of Hijri Month, Is it Possible in Axapta, Can you Throw some light.
Thanks & Regards,
Ansar.
Hi Ansar,
As you see, I’m using the .NET framework capabilities by the end of the day to get the Hijri Date. So you have to think the same way. I’m not sure what the method in .NET actually is, you have to look for it buddy.
All the luck :).
Amer
Hi Amer,
Thanks for your quick reply, I need to generate the Revenue Journal by end of each month for Hijri date, i have stuck up for converting the end date.
Thanks :-),
Ansar.