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.