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 –
- 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
- 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.