CODEWITHSUNDEEP
javascriptsharepointsharepoint-2013
ysfibm
ysfibm

Reputation: 436

SharePoint 2013 calculated column ( text + date )

I have a column (created) witch the type is date ,and another column author witch the type is text , I wanna put the result of (author+created) in a calculated column ,I tried this and it doesn't work: [author]&" "&TEXT([Created], "mmm-dd-yyyy"),I have this error : Sorry ... We have encountered a problem The formula contains a syntax error or is not supported

can we put text + date in a calculated column? any solution? can we do it with JavaScript ?

Upvotes: 0

Views: 1103

Answers (1)

Verthosa
Verthosa

Reputation: 1688

You formula seems to be correct. I did a test and it works on my dev machine. What can happen is that the formula for the date can be different due to your locale settings and language activation. The same goes for the name of the functions. For example: if my language is English, then TEXT-function will be recognized. But when for example Dutch is the language activated, i will have to use TEKST-function instead. Also the date format will be different so you might want to lookup the locale/datemask for your specific language. Another important remarque is that in some language, the Excel-formulas (because that's what they are) sometimes take a , as delimiter and sometimes a ;.

So you might also want to play with this:

TEXT([Created], "mmm-dd-yyyy")

TEXT([Created]; "mmm-dd-yyyy")

Another hint i can give you is just writing the formulas in Excel. If they work there, they should also work in SharePoint calculated column.

Upvotes: 2

Related Questions