How can I set date format in SharePoint to the international standard: YYYY-MM-DD (ISO 8601)?

Question

_{Friday, June 4, 2010 3:53 PM | 2 votes}

I live and work in the USA, but have many global projects on my SharePoint site.  The ISO date format (YYYY-MM-DD) is the most clear and logical date format.  I want to be able to use it in SharePoint like I can in other Microsoft Office products... (scream!!!)

All replies (6)

_{Wednesday, August 10, 2011 7:31 AM ✅Answered}

Check the below link

http://www.fewlines4biju.com/2011/08/change-dateformat-in-sharepoint.html

Thanks Bijay @HP, Bangalore http://www.fewlines4biju.com http://www.onlysharepoint2010.com

---

_{Tuesday, October 25, 2011 7:05 AM ✅Answered}

Another approach:

Here Date Format is mm/dd/yyyy

Step 1) Download the Jquery Masked Input Plug-In from
http://digitalbush.com/projects/masked-input-plugin/

Step 2) Upload the Jquery.js and jquery.maskedinput-1.3 to the site assets or generalized location where the script files are kept

Step 2) Open a notepad and enter the below JQuery code and save it with some file name [DateMasking.txt]

<script src="../../scripts/jquery-1.3.2.js"></script> 
<script src="../../scripts/jquery.maskedinput-1.2.2.min.js"></script> 

<script type="text/javascript"> 
 $(document).ready(function() { 
 $("input[title='ColumnName']").mask("99/99/9999"); }); 
</script>

 

Amalaraja Fernando, Technical Architect - SharePoint Collaboration, Mphasis Limited.

---

_{Saturday, June 5, 2010 9:14 PM}

SharePoint adapts to the user's regional preferences. So go to the Welcome menu (your name in the top right) and select My Settings. Click My Regional Settings and uncheckmark "Always follow web settings". Then change your locale to one that uses the formats you like.  For example, Japanese will get you the date format, but will also do strange things to the calendar.  I tried a few, and one that seems to get what you want is "English (South Africa)".Mike Smith TechTrainingNotes.blogspot.com

---

_{Tuesday, August 9, 2011 6:14 AM}

Try this 

 

http://www.informationworker.co.za/blogs/BramsOnSharePoint/Lists/Posts/Post.aspx?ID=2

Thanks Bijay @HP, Bangalore http://www.fewlines4biju.com http://www.onlysharepoint2010.com

---

_{Tuesday, August 9, 2011 7:08 AM}

One other running forum for the same purpose

http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/75e5b5ad-685c-471e-8c00-09df97dac001

Regards, Dharnendra Shah "strong belief is the only way to success"

---

_{Wednesday, October 19, 2011 12:42 PM}

Create a new Calculated column
In the Forumla box, enter something like this: =TEXT([existing date column],"yyyy-mm-dd")
Make the data type "Date and Time"
Make the date and time format "Date Only"Amalaraja Fernando, Technical Architect - SharePoint Collaboration, Mphasis Limited.