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.
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.
- Edited by kellehbeans Friday, June 22, 2012 1:27 PM added more detail
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.