Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Change date format for...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Change date format for language

(0) ShareShare
ReportReport
Posted on by MelanieF 10

Hello everyone,

Is it possible to change the date format for a specific language? For example, the date format for the language /nl/ (Netherlands) is currently 29/09/2023, but we would like to display it as 29.09.2023 on our documents.  I'm aware that I can adjust the date format in my user settings, but the reports seem to pick up the date format from the language setting used for customers, vendors, and so on.

Can anyone help me with this?

Thank you very much in advance!

  • Suggested answer
    CS Lingam Profile Picture
    CS Lingam 47 on at
    Change date format for language
    Hello Melanie,
     
    Standard:
    • If you provide specific language at Date, time and number format field, system will print that pre-defined format on your reports.
    • If you let same field as empty, it will print based on the language you set on Language field. 
     
    If you want any specific date format on report, then you have to go for report customization.
     
     
    Regards,
    CS Lingam
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    Change date format for language
    Hi Melanie,
     
    Fasih shared my blog where you can personalize the date and time format. Note that my code example is only working for dates presented on forms, not on SSRS reports. In case you need to have another date format on reports, it would require some configuration or development on the report itself.
  • Fasih Profile Picture
    Fasih 293 on at
    Change date format for language
    Hi, please refer below link to change date, time format accordingly. 
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans