Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

How to change format of DateTime field to MM/YYYY?

(0) ShareShare
ReportReport
Posted on by 280

Hello All,

I have a requirement to show the Date value for the DateTime field on CRM form in MM/YYYY format instead of MM/DD/YYYY format.

Any pointers?

Thanks,

Swaroop

*This post is locked for comments

  • Royal King Profile Picture
    Royal King 27,686 on at
    RE: How to change format of DateTime field to MM/YYYY?

    It not possible using OOB. You have to use another text build to store this information and copy only MM/YYYY  from actual field. For this you can javascript/workflow/plugin.

  • Suggested answer
    Aiden Kaskela Profile Picture
    Aiden Kaskela 19,694 on at
    RE: How to change format of DateTime field to MM/YYYY?

    Hi Swaroop,

    CRM doesn't support dates that don't have a day specific (though I really wish they did sometimes). One way that you can mimic it is to have a date field for the actual date, and a text field for the MM/YYYY display value. Any time you need to set the date you would have to set the actual date field, but a custom plugin would set your text field to the formatted value. Another thing you could do would be to have to Whole Number fields side by side for Month and Year, but you wouldn't be able to do any date based comparisons on them.

    Hope this helps, if so, I would appreciate if you would mark this as the verified answer.

    Thanks,

     Aiden

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to change format of DateTime field to MM/YYYY?

    Well, I believe that there is no way doing this by configurations, maybe a plugin, but I really don't know how, I hope some guru come here to help.

    ; )

  • Swaroop Deshmukh Profile Picture
    Swaroop Deshmukh 280 on at
    RE: How to change format of DateTime field to MM/YYYY?

    Hello JoaoL & Chitra,

    The System Configuration settings doesn't give me an option to set the MM/YYYY format. I don't want the day (DD) to be displayed on the form.

    And I am looking to set it to a particular field only.

    Thanks,

    Swaroop

  • Royal King Profile Picture
    Royal King 27,686 on at
    RE: How to change format of DateTime field to MM/YYYY?

    you can change the date format by going to settings->Administration->System Settings-> CLick on format tab where you change date format to match your requirement.

    5037.Capture.PNG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to change format of DateTime field to MM/YYYY?

    you want to change the format of all fields, or only one?

    in case you want to change all fields, you can go to : Conf > administration > System Conf. > than go to the tab Formats and change the format of the dates, as you wish.

    Hope it helps, if you want to change only one field... than I don't know how to achieve it.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans