MOSS2007 + SP2 (Turkish) Calculated Column not accepting METİN formula


Hi Everyone,

if you try suggested formula  for Sharepoint Calculated Column (MOSS2007 with Turkish Language Pack)  on fallowing official article http://office.microsoft.com/tr-tr/sharepoint-foundation-help/HA010379915.aspx and the help document of wss like
=”Ekstre tarihi: “&METİN([Sütun2], “gg-aa-yyyy”)

is not working  and getting error of “Söz dizimi hatası”

Cause :Should be a documentation error .

The formula should be “METNEÇEVİR” instead of “METİN” and the splitter should be “;” instead of “,”

Here is the correct version of formula:
=”Ekstre tarihi: “&METNEÇEVİR([Sütun2];”gg-aa-yyyy”)

You may getting some errors for other formulas please read fallowing warning and always keep in mind:

“All example formulas in this topic use commas “,” as the parameter delimiter character. In some countries, the comma is reserved for use as the decimal mark. In such countries, users creating a calculated field must use semi-colons “;” as the delimiter character. Regardless of which character is used when the field is created, the formula works on lists in SharePoint websites anywhere in the world. SharePoint automatically changes the delimiter character to the one that is appropriate for the language/culture of the current page. For example, suppose the following formula is created on a website whose culture setting is fr-fr (France): =IF(Number1>Number2;5;10). If the website’s culture is then changed to en-us (United States), the formula changes automatically to: =IF(Number1>Number2,5,10).”
http://msdn.microsoft.com/en-us/library/bb862071.aspx

Advertisement

About bpostaci
Escalation Engineer in Microsoft.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: