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
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.
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
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.
; )
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
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.
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.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156