Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

MS D365 FO - Personalize Date Format DD-MMM-YYYY; Example - 06-May-2023

(1) ShareShare
ReportReport
Posted on by 222

Hi,

We have got a requirement from one of the D365 FO customer where we could not achieve through out of box configuration.

Hence, posting here for innovative idea to achieve the requirement through customization/configuration. Thanks.!

Requirement – “MS Dynamics 365 F&O application should be able to display the date in the format DD-MMM-YYYY Example – 06-May-2023 and this should be applicable to all legal entities irrespective of the company region." 

Challenge – We don’t have a specific configuration form available out of box to setup the required date format in MS Dynamics 365 F&O

Additional Info –

  1. The D365 FO has the user specific regional configuration which could display the date, time, and number format as per the regional specifications. However, this configuration is not satisfying the requirement. Path - Modules > System administration > Users > Users> User options>Preferences> Date time & number format
  2. I could able to partially achieve the requirement by subscribing to the onFormRun event of FormRun class and make some customizations to display the date as per required format. Followed the solution detailed in the web page  https://dynamicspedia.com/2023/04/more-options-to-personalize-the-date-and-time-format/   However, I could not able to find a way on customization to display the customs date format on SSRS Reports and Query filters. 
  • anil1268 Profile Picture
    222 on at
    RE: MS D365 FO - Personalize Date Format DD-MMM-YYYY; Example - 06-May-2023

    Hi Andre,

    Your blog post really valuable and its a good attempt to try something which is not provided by Microsoft by default. This kind of requirement is very rear, but this feature sounds very simple and has to be provided by Microsoft to enable the users to choose the Date Personalization as per the business requirement.

  • André Arnaud de Calavon Profile Picture
    293,274 Super User 2025 Season 1 on at
    RE: MS D365 FO - Personalize Date Format DD-MMM-YYYY; Example - 06-May-2023

    Hi Anil,

    I'm glad you found my blog post which would help you with the user interface in the application. I think myself that the query filters would be impossible. This is expecting a particular date format. For reports, you would need to customize each single report to get the desired outcome.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,274 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,947 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans