change of date format after cretion of users. RRS feed

  • Question

  • Hi,

    I want to change date format from d/mm/yy to dd/mm/yy and as there are lot of users I cant change

    user level settings.So I modified in the database

    update UserSettings set DateFormatString ='dd/MM/yy' .

    It got modified in the database, but in crm it's still showing as d/mm/yy(in options-->formats-->date fromat) and also when I open a recoed it's showing as d/mm/yy only.

    Please help.




    Tuesday, March 12, 2013 1:22 AM

All replies

  • Hi,

    You can change date format from System -> Administration -> System Settings -> Formats. It is not recommended to modify in the database.

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Thanks and Regards, Yogesh Vijay Mulay

    Tuesday, March 12, 2013 3:27 AM
  • Hi,

    Thanks for suggetion.I'm aware of that.But after user creation if we change that setting ,it wont reflect at user level.Even if it's unsupported way it's ok, as we want to do this change in development/uat environment.

    Tuesday, March 12, 2013 4:08 AM