Article ID: 887922 - Last Review: August 25, 2008 - Revision: 1.1 Date calculated List field error in Arabic LanguageSYMPTOMSThis 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) RESOLUTIONWhen 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”)
| Article Translations
|
Back to the top
