Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

How to change Behavior field of a Date and Time Data Type without having to recreate the field?

Posted on by 2,645

We have a user request to make all date fields on an entity to have the behavior of Date Only.  Some say that already, but others say User Local.  How can I change the User Local to be Date Only without having to recreate the entire field?

*This post is locked for comments

  • RE: How to change Behavior field of a Date and Time Data Type without having to recreate the field?

    I am not even able to make changes in the behavior on Custom Date fields. I have strange situation as one Organization it allows, but in other organization it doesn't. I know it is imported as Managed custom fields in the other target organization. How do we convert Custom Date fields from Managed to Unmanaged so that we can modify behavior of custom date field?

  • Verified answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: How to change Behavior field of a Date and Time Data Type without having to recreate the field?

    Hello ,

    Unfortunately you can not change system field behavior , you may create custom field for that.

  • USA80 Profile Picture
    USA80 2,645 on at
    RE: How to change Behavior field of a Date and Time Data Type without having to recreate the field?

    This doesn't help me as the field doesn't even show up under the Fields for the entity.  Can I not change Contract Start Date and Contract End Date behaviors?

  • USA80 Profile Picture
    USA80 2,645 on at
    RE: How to change Behavior field of a Date and Time Data Type without having to recreate the field?

    Also, this field doesn't show up under the Fields of the entity for some reason.  Not sure if it is an out of the box field.

  • USA80 Profile Picture
    USA80 2,645 on at
    RE: How to change Behavior field of a Date and Time Data Type without having to recreate the field?

    The field I am questioning is on the Contract entity.  There is a field called, "Contract Start Date", this field for the behavior says Use Local, when I need it to say Date Only.  I am unable to change it.  Your method that you mentioned, does not work as well for any of my date fields as the behavior is grayed out.

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,756 on at
    RE: How to change Behavior field of a Date and Time Data Type without having to recreate the field?

    Hi,

    Without explaining anything here - i would like you to go through below which is very well explained and tells you the limitation , precautions etc of doing this:

    General Date and time fields : technet.microsoft.com/.../dn946904.aspx

    changing the fields behavior : technet.microsoft.com/.../dn946904.aspx

    hope this helps!

  • Suggested answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at
    RE: How to change Behavior field of a Date and Time Data Type without having to recreate the field?

    Hi

    Can you try to:

    1. Navigate to Settings - Customizations - Customize the System
    2. Expand Entities
    3. Expand the Entity where you want to modify the field
    4. Click on Fields
    5. Double click on the Field you want to modify - to open it - Try to change the Behavior from there.
    6. Save and Publish All Customizations

    Hope this helps,

    Radu

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans