Article ID: 887922 - Last Review: August 25, 2008 - Revision: 1.1

Date calculated List field error in Arabic Language

Expand all | Collapse all

SYMPTOMS

This problem occurs when system Locale is Arabic (e.g. Arabic (Kuwait)) and the user try to use Date formula for a calculated field in a custom list (WSS).
For example, when trying to present the Year, Month or day from a Date Only field (i.e. 2004 from 30/08/2004), the following forms will generate an error although it may work correctly on non Arabic system Locale (e.g. English (US)):
o Day (i.e. =TEXT([Date],”yyyy”)
o Month (need August, September, etc, i.e. =TEXT([Date],”mmmm”)
o Day (i.e. =TEXT([Date],”dd”)

If the formula will be typed in the following form, it will work correctly:
o =YEAR([Date])
o =YEAR([التاريخ])

The previous formula will show the year as 2,004, and to prevent viewing this comma, the user may need to use the following formula which causes an error:
o TEXT(field,format)

RESOLUTION

When the System Locale is set to Arabic then the list separator is ";" (semi-column) not a"," (comma).
The users should use SEMI-OLUMN instead of COMMA in all the formulas
o Day (i.e. =TEXT([Date];”yyyy”)
o Month (=TEXT([Date];”mmmm”)
o Day (i.e. =TEXT([Date];”dd”)

APPLIES TO
  • Microsoft Windows SharePoint Services 2.0
Keywords: 
kbprb kbhowto kblangsupparabic kbbidi KB887922
 

Article Translations

 

Related Support Centers