I am looking to change the datetime format with in the modified column from mm/dd/yy to dd MMM yyyy. I dont want to create calculated field with dd MMM yyyy format. I want the actual modified column value to be represented as dd MMM yyyy format.
Thanks for your help in advance.
Todas as Respostas
I'm not really sure what context you asking to change this for but to change your date time settings -
Go into Site Settings and under 'Central Administration' there is a link to 'Regional Settings'. Click this and you specify the way dates and times are displayed.
I have done this and mine displays as DD/MM/YYYY like you are asking.
My locale is current set to English (United Kingdom) and sort order is general. Even if you're not in the United Kingdom, I can only see this way being your solution as US dates are always set as MM/DD/YYYY.
- Editado kellehbeans sexta-feira, 22 de junho de 2012 13:27 added more detail
Here is the screenshot. These sharepoint dates that I am talking about. I have different sites within the site collection each site has to have different locale, but the date format should be dd MMM yyyy across all the sites just for the consistency.
Oh! I see what you mean, so actually having the characters for the month after than actually the number of the month. (Sorry, I thought the MMM was a typing error, it never occurred to me that it may be that way!)
Now that you have pointed out that, I have no idea. I've just looked around my site and found no way to change this, perhaps there is an application that can help you change this?
Good luck, and sorry I could not help any further.