Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Bulk update Date Forma...
Microsoft Dynamics CRM (Archived)

Bulk update Date Formats in User Personal Settings

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

Is there a way to bulk update  Date Formats for multiple users? Our global setting is set to the correct format but the format the user level setting is not correct. I believe that the "User" level  setting inherits from the global setting when the users are being added. In our environment the users were added first and the global date format was changed retrospectively.

I have tried looking at the XrmToolBox, but its User Settings Utility does not give an option to set the "formats".  Please let me know if there is an out of the box way to change date format for multiple users.

Thanks,

Nishant

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bulk update Date Formats in User Personal Settings

    Thanks Gopalan!! I will give this a try and let you know.

  • Verified answer
    Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,397 on at
    RE: Bulk update Date Formats in User Personal Settings

    Hi

    If you want to do it through code,

    Get all the records of UserSettings entity

    and update the attribute values, accordingly

               userSettingsEntity.Attributes["homepagearea"] = "Sales"

               userSettingsEntity.Attributes["currencysymbol"] = "£"

               userSettingsEntity.Attributes["localeid"] = 2057

               userSettingsEntity.Attributes["homepagesubarea"] = "nav_dashboards"

               userSettingsEntity.Attributes["dateformatstring"] = "dd/MM/yyyy"

               userSettingsEntity.Attributes["timeformatstring"] = "HH:mm"

               userSettingsEntity.Attributes["timezonecode"] = 85

    stackoverflow.com/.../settings-crm-systemusers-personal-options-in-code

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans