I have created a calculated field for a content type in my Sharepoint 2010 and I want to return a date in the TEXT format because I am returning some text with it. The condition I have put in the formula is:
IF(
AND([ShowModifiedDate];[ShowCreatedDate]);
"Create date is [Created] and update date is [Modified]";
IF(
[ShowModifiedDate];
[Modified];
IF(
[ShowCreatedDate];
[Created];
[ArticleDate]
)
)
)
Here I have to return the result in "Single Line of Text" instead of "Date time". I have tried TEXT function (TEXT([Modified],"dd-mm-yyyy")
) for the same but it's always giving an error "The formula contains a syntax error or is not supported.". But I can't see any error in the query which I am returning. I have all the columns present in the list.
Even though if I write below thing in formula it's returning me the same error..
TEXT([Modified],"dd mmm yyyy hh:mm ")
Any help would be appreciated.