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.
<xsl:value-of select="ddwrt:FormatDate(string(@StartDate), [LCID],[FORMAT FLAG])"/>
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.
<xsl:value-of select="ddwrt:FormatDate(string(@StartDate), [LCID],[FORMAT FLAG])"/>
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) |
No comments:
Post a Comment