Share via

How can i change date format only MM/YYYY to list column without Calculated Type?

Question

Thursday, January 17, 2013 4:27 AM | 1 vote

Hello,

In my sharepoint list, i have to one column that data type is Date And Time Format. By default "16-1-2013" but i need to display in this format like "MM/YYYY" but without Calculated Column.

All replies (9)

Friday, January 18, 2013 9:10 AM ✅Answered | 1 vote

Hi Prakash,

As Hemendra said, it is not possible with OOB solution to only show a Date & time type of field with “MM/YYYY” format.

We can change the date format to “DD/MM/YYYY hh:mm” by changing Calendar option to “Gregorian” in Site Settings > Regional Settings.

And to only show MM/YYYYY, please consider using

  1. A column with single text type. Add validation to this column so that only string with MM/YYYY format could be saved in custom list form (with InfoPath).
  2. I would like suggest you use calculated column. I think it is a convenient method to resolve this problem.
  3. Modify list view in SharePoint Designer.

Thanks & Regards,
Emir

Emir Liu
TechNet Community Support

Thursday, January 17, 2013 5:28 AM | 1 vote

Hi,

How about regional settings?

Site Actions / Site Settings / Modify All Site Settings / Site Administration / Regional Settings / select zone as per you need.

Is it helpful?

Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

Whenever you see a reply and if you think is helpful, click "Vote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Mark As Answer

Thursday, January 17, 2013 6:03 AM | 1 vote

Sorry, I tried it.. it is not helpful..

Thursday, January 17, 2013 6:41 AM | 1 vote

Hi,

>MM/YYYY

Yes, this will not work because every locale in regional settings comes with date as well but you don't want date. Only calculate column or code or powershell can help you, where you can overwrite the date.

Hope it could help

Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

Whenever you see a reply and if you think is helpful, click "Vote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Mark As Answer

Thursday, January 17, 2013 6:45 AM | 1 vote

Hi

think different

Don't change list' columns,

change how these values are displayed, using for example SHP Designer which is free and easy to use.

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

Thursday, January 17, 2013 7:14 AM | 1 vote

Hi,

Thnks

Thursday, January 17, 2013 8:40 AM

Hi,

You can do this by possibly changing xslt that renders list. You can use ms:format-date function ( http://msdn.microsoft.com/en-us/library/ms256099.aspx) function to do that.

~ DP

Thursday, January 17, 2013 9:00 AM | 1 vote

Hi,

Ok.... But i want to do Out-Of-Box, not using xls...!!!

Saturday, January 19, 2013 6:43 AM | 1 vote

Hi Emir Liu,

Thank you.... i done you to given that solution...