How to completely convert the date system in D365 F&O from Gregorian to Hijri?

(1) Share

Report

Posted on by Ali AbdAlNasser

405

Hello everyone,

I am working on a project that requires displaying dates in the Hijri calendar throughout the Dynamics 365 Finance and Operations system, including:

- Forms: Displaying all dates in the forms in the Hijri calendar.
- Reports: Printing and showing Hijri dates in all issued reports.
- Queries and Custom Reports: Modifying dates in query results to Hijri.
- Any other components or parts that deal with dates within the system.

I understand that the system primarily relies on Gregorian dates, and that modifying the entire date system is challenging since Gregorian dates are embedded in the system's infrastructure. I have attempted to implement custom solutions but to no avail, but I wonder if there is a more comprehensive solution or setup that would allow me to fully adopt the Hijri calendar in the system.

Are there any recommendations or effective solutions to apply this modification across all parts of the system?

Thank you in advance for your assistance!

I have the same question (0)

All responses (7)

Answers (1)

Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (2)

Report

There is no support for non-Gregorian calendars in F&O for any of its controls, and you will never be able to customize F&O to support it. You could write a browser plugin, but then what happens if there is a bug in the browser plugin that broke all dates?

The question is, how much of the application really needs to be in Hijri? Would it make sense to create specific forms where this date format is required?

Was this reply helpful? Yes No
Ali AbdAlNasser 405 on at

Like (1)

Report

Hello Jonas,
I am happy to receive a response from you to my question, but I was asked for this customization and I found it difficult to do, so I asked this question to make sure there is a way to do it or not.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (2)

Report

No, there is no way to do this customization in F&O.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at

Like (1)

Report

Hi Ali,

This can't be achieved through a D365 X++ function, however you will have to write something like this.

This can be achieved through the below SSRS Expression.

1. IIf(Parameters!DATE1.Value >0 ,FORMAT(CDate(Mid(Parameters!DATE1.Value,5,2) + "-" +
Right(Parameters!DATE1.Value,2) + "-" + Left(Parameters!DATE1.Value,4)),"dd-MM-yyyy"),"")

or you can have the same function like in the SSRS expression using the System.Globalization inbuilt function. =FORMAT(Fields!Date1.Value,"dd-MM-yyyy", System.Globalization.CultureInfo.CreateSpecificCulture("ar-SA"))

If FORMAT function using the CDate doesn't work then you can use the System.Globalization inside the FORMAT function, as mentioned above.

Assumptions:

1. Hope you have the Regional language and settings in Windows set to accept Hijri calendar.

Was this reply helpful? Yes No
Ali AbdAlNasser 405 on at

Like (1)

Report

Hello Navneeth,

I want to change the Gregorian date to the Hijri date for the entire system, not just SSRS reports.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (2)

Report

Hi Ali,

As mentioned it is not supported. Customizing the whole application is far from recommended. What is the exact purpose for having the Hijri calendar everywhere in the application? Isn't it more useful to focus on specific forms or reports?

You can consider creating an idea on https://ideas.dynamics.com. So far, this topic is not discussed for Dynamics 365 F&O. There are two ideas related to Hijri calendar for CRM, but a few votes only. In case there will be a lot of votes, it will become visible for Microsoft to consider implementing such a feature.

Was this reply helpful? Yes No
Verified answer

Ali AbdAlNasser 405 on at

Like (1)

Report

Hello André,

I am happy to receive a response from you, and it seems that the idea of changing the date system from Gregorian to Hijri is somewhat difficult. I think I will just settle for customizing some reports and forms.

Was this reply helpful? Yes No