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

(0) Share

Report

Posted on by Swaroop Deshmukh

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

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Swaroop Deshmukh 280 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

; )

Was this reply helpful? Yes No
Suggested answer

Aiden Kaskela 19,696 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (1)

Report

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.

Was this reply helpful? Yes No