CODEWITHSUNDEEP
excelsharepointsharepoint-2013vba
ysfibm
ysfibm

Reputation: 436

calculated column (texte + date ) in sharepoint

I wanna create a calculated column in sharepoint 2013 that contains value of 2 columns, a text column and date , Example calculated column = [column 1 (text)]+[column 2(date )]

I tryed this : 

=[Colonne1]&" "&TEXTE([Colonne2], "mmm-dd-yyyy")

but I have a syntax error ,

thank you for the help

Info:my format language is French

Upvotes: 0

Views: 1131

Answers (2)

William Meisheid
William Meisheid

Reputation: 1

Here is a post on how to convert your date to a string.

how-to-convert-date-field-in-single-line-of-text-using-calculated-columns

I hope that helps.

Upvotes: 0

William Meisheid
William Meisheid

Reputation: 1

I may be wrong but I think the problem is that you are mixing data types (text & date) so I would try first converting the date to text and then combining the results (text & text).

Upvotes: 0

Related Questions