Show only month and year in datetime picker custom list

Question

_{Thursday, March 7, 2013 11:48 AM | 1 vote}

Hi,

I have a custom list. I am trying to add a Datetime picker column. However i would like to show only the Month and year.

How to achieve this? Is this possible OOB?

Thanks

All replies (3)

_{Thursday, March 7, 2013 12:54 PM ✅Answered}

If all you want to do is display the Month/year after selecting the date from the popup you could create a calculated field that displays the format that you want

formatted date "=TEXT(pickdate,"m") & "/" & YEAR(pickdate)"

where pickdate is your date time picker field. Just remove the pickdate column from your view to keep it hidden

_{Thursday, March 7, 2013 12:13 PM}

Out of box, it won't be possible.Because the date format is in dd/mm/yyyy format.If you want any default value in your date like "01", then it is possible using jquery.

_{Thursday, March 7, 2013 12:39 PM}

HI,

Thanks for the reply.

I just want to show the month and year.