Format date value in data view webpart in SharePoint 2010

InfoPath alternatives for form designing SharePoint

In this post we will discuss how we can format a date value in data view web part in SharePoint 2010. Also you can check out some posts on:

– Deploy jQuery to site assets library using SharePoint solution package

– Hosting options in SharePoint 2013

– Make People Picker read only in SharePoint 2010 list form using jQuery

There are various ways to format date values in a SharePoint Data View Web Part using xslt.

To be able to use the FormatDate function, add the DDWRT name space reference in the top section.

xmlns:ddwrt=http://schemas.microsoft.com/WebParts/v2/DataView/runtime

In SharePoint Designer Xpath Method Add  FormatDate(Columnname,LCID,FormatFlat) method.

Format date value in data view webpart in SharePoint 2010
Format date value in data view webpart in SharePoint 2010

Format Flag


Format Flag Example
1 MM/dd/yyyy. ==> “08/17/2000?
3 dddd, MM dd, yyyy. ==> “Thursday, August 17, 2000?
4 h:mm. ==> “16:32?
5 MM/dd/yyyy h:mm. ==> “08/17/2000 16:32?
7 dddd, MM dd, yyyy h:mm. ==> “Thursday, August 17, 2000 16:32?
12 h:mm:ss. ==> “16:32:32?
13 MM/dd/yyyy h:mm:ss. ==> “08/17/2000 16:32:32?
15 dddd, MMMM dd, yyyy h:mm:ss. ==> “Thursday, August 17, 2000 16:32:32”

LCID is a language code:

Language LCID
Afrikaans 1078 (&H436)
Albanian 1052 (&H41C)
Arabic 1025 (&H401)
Arabic Algeria 5121 (&H1401)
Arabic Bahrain 15361 (&H3C01)
Arabic Egypt 3073 (&HC01)
Arabic Iraq 2049 (&H801)
Arabic Jordan 11265 (&H2C01)
Arabic Kuwait 13313 (&H3401)
Arabic Lebanon 12289 (&H3001)
Arabic Libya 4097 (&H1001)
Arabic Morocco 6145 (&H1801)
Arabic Oman 8193 (&H2001)
Arabic Qatar 16385 (&H4001)
Arabic Saudi Arabia 1025 (&H401)
Arabic Syria 10241 (&H2801)
Arabic Tunisia 7169 (&H1C01)
Arabic U.A.E 14337 (&H3801
Arabic Yemen 9217 (&H2401)
Armenian 1067 (&H42B)
Assamese 1101 (&H44D)
Azeri Cyrillic 2092 (&H82C)
Azeri Latin 1068 (&H42C)
Basque 1069 (&H42D)
Belgian Dutch 2067 (&H813)
Belgian French 2060 (&H80C)
Bengali 1093 (&H445)
Portuguese (Brazil) 1046 (&H416)
Bulgarian 1026 (&H402)
Burmese 1109 (&H455)
Byelorussian (Belarusian) 1059 (&H423)
Catalan 1027 (&H403)
Chinese Hong Kong SAR 3076 (&HC04)
Chinese Macau SAR 5124 (&H1404)
Chinese Simplified 2052 (&H804)
Chinese Singapore 4100 (&H1004)
Chinese Traditional 1028 (&H404)
Croatian 1050 (&H41A)
Czech 1029 (&H405)
Danish 1030 (&H406)
Dutch 1043 (&H413)
English Australia 3081 (&HC09)
English Belize 10249 (&H2809)
English Canadian 4105 (&H1009)
English Caribbean 9225 (&H2409)
English Ireland 6153 (&H1809)
English Jamaica 8201 (&H2009)
English New Zealand 5129 (&H1409)
English Philippines 13321 (&H3409)
English South Africa 7177 (&H1C09)
English Trinidad 11273 (&H2C09)
English U.K. 2057 (&H809)
English U.S. 1033 (&H409)
English Zimbabwe 12297 (&H3009)
Estonian 1061 (&H425)
Faeroese 1080 (&H438)
Farsi 1065 (&H429)
Finnish 1035 (&H40B)
French 1036 (&H40C)
French Cameroon 11276 (&H2C0C)
French Canadian 3084 (&HC0C)
French Cote d’Ivoire 12300 (&H300C)
French Luxembourg 5132 (&H140C)
French Mali 13324 (&H340C)
French Monaco 6156 (&H180C)
French Reunion 8204 (&H200C)
French Senegal 10252 (&H280C)
French West Indies 7180 (&H1C0C)
French Congo (DRC) 9228 (&H240C)
Frisian Netherlands 1122 (&H462)
Gaelic Ireland 2108 (&H83C)
Gaelic Scotland 1084 (&H43C)
Galician 1110 (&H456)
Georgian 1079 (&H437)
German 1031 (&H407)
German Austria 3079 (&HC07)
German Liechtenstein 5127 (&H1407)
German Luxembourg 4103 (&H1007)
Greek 1032 (&H408)
Gujarati 1095 (&H447)
Hebrew 1037 (&H40D)
Hindi 1081 (&H439)
Hungarian 1038 (&H40E)
Icelandic 1039 (&H40F)
Indonesian 1057 (&H421)
Italian 1040 (&H410)
Japanese 1041 (&H411)
Kannada 1099 (&H44B)
Kashmiri 1120 (&H460)
Kazakh 1087 (&H43F)
Khmer 1107 (&H453)
Kirghiz 1088 (&H440)
Konkani 1111 (&H457)
Korean 1042 (&H412)
Lao 1108 (&H454)
Latvian 1062 (&H426)
Lithuanian 1063 (&H427)
FYRO Macedonian 1071 (&H42F)
Malayalam 1100 (&H44C)
Malay Brunei Darussalam 2110 (&H83E)
Malaysian 1086 (&H43E)
Maltese 1082 (&H43A)
Manipuri 1112 (&H458)
Marathi 1102 (&H44E)
Mongolian 1104 (&H450)
Nepali 1121 (&H461)
Norwegian Bokmol 1044 (&H414)
Norwegian Nynorsk 2068 (&H814)
Oriya 1096 (&H448)
Polish 1045 (&H415)
Portuguese 2070 (&H816)
Punjabi 1094 (&H446)
Rhaeto-Romanic 1047 (&H417)
Romanian 1048 (&H418)
Romanian Moldova 2072 (&H818)
Russian 1049 (&H419)
Russian Moldova 2073 (&H819)
Sami Lappish 1083 (&H43B)
Sanskrit 1103 (&H44F)
Serbian Cyrillic 3098 (&HC1A)
Serbian Latin 2074 (&H81A)
Sesotho 1072 (&H430)
Sindhi 1113 (&H459)
Slovak 1051 (&H41B)
Slovenian 1060 (&H424)
Sorbian 1070 (&H42E)
Spanish (Traditional) 1034 (&H40A)
Spanish Argentina 11274 (&H2C0A)
Spanish Bolivia 16394 (&H400A)
Spanish Chile 13322 (&H340A)
Spanish Colombia 9226 (&H240A)
Spanish Costa Rica 5130 (&H140A)
Spanish Dominican Republic 7178 (&H1C0A)
Spanish Ecuador 12298 (&H300A)
Spanish El Salvador 17418 (&H440A)
Spanish Guatemala 4106 (&H100A)
Spanish Honduras 18442 (&H480A)
Spanish Nicaragua 19466 (&H4C0A)
Spanish Panama 6154 (&H180A)
Spanish Paraguay 15370 (H3C0A)
Spanish Peru 10250 (&H280A)
Spanish Puerto Rico 20490 (&H500A)
Spanish Spain (Modern Sort) 3082 (&HC0A)
Spanish Uruguay 14346 (&H380A)
Spanish Venezuela 8202 (&H200A)
Sutu 1072 (&H430)
Swahili 1089 (&H441)
Swedish 1053 (&H41D)
Swedish Finland 2077 (&H81D)
Swiss French 4108 (&H100C)
Swiss German 2055 (&H807)
Swiss Italian 2064 (&H810)
Tajik 1064 (&H428)
Tamil 1097 (&H449)
Tatar 1092 (&H444)
Telugu 1098 (&H44A)
Thai 1054 (&H41E)
Tibetan 1105 (&H451)
Tsonga 1073 (&H431)
Tswana 1074 (&H432)
Turkish 1055 (&H41F)
Turkmen 1090 (&H442)
Ukrainian 1058 (&H422)
Urdu 1056 (&H420)
Uzbek Cyrillic 2115 (&H843)
Uzbek Latin 1091 (&H443)
Venda 1075 (&H433)
Vietnamese 1066 (&H42A)
Welsh 1106 (&H452)
Xhosa 1076 (&H434)
Zulu 1077 (&H435)

Similar SharePoint 2013 Tutorials


About Sagar Pardeshi

I am Developer working on Microsoft Technologies for the past 6+years. I am very much passionate about programming and my core skills are SharePoint, ASP.NET & C#,Jquery,Javascript,REST. I am running this blog to share my experience & learning with the community I am an MCP, MCTS .NET & Sharepoint 2010, MCPD Sharepoint 2010, and MCSD HTML 5,Sharepoint 2013 Core Solutions. I am currently working on Sharepoint 2010, MOSS 2007, Sharepoint 2013,Sharepoint 2013 App Dev, C#, ASP.NET, and SQL Server 2008.

View all posts by Sagar Pardeshi →

Leave a Reply