How to convert date field in single line of text using Calculated columns

Question

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.

Answer 1

Did you put the "=" in front of the formula in the calculated field?

See pictures below, it worked for me

Answer 2

If as DateTime its working fine then you can also use the following to get the text

DAY(Modified)&"-"&MONTH(Modified)&"-"&YEAR(Modified)

Answer 3

It seems like you're mixing semicolon separators ; (in your main formula) and comma separators , (in the TEXT function).

It's also worth double-checking all your field names are correct: It may be a translation difference, but the [Changed] and [Change] fields are usually called [Modified].