I created a field in list as DOB (Date and Time type). I want to display DOB in the format of '1 Oct 2013'. How can I achieve this? Is it possible to do by Calculated Value property?

2 Answers 2


As far as I know, this is not possible by using "Calculated Value" property of "DOB" column as self referral is not allowed.

What you can do is create a new "Calculated" column and then use formula =TEXT(DOB,"dd MMM yyyy"). Select "Date and Time" in data type returned and use "Date only" in format.

This will solve your purpose.

  • Better yet, wrap that in an IF statement to deal with empty dates. For example: =IF(DOB<>"",TEXT(DOB,"dd MMM yyyy","").
    – Chiramisu
    Aug 10, 2018 at 21:37

Yes, you can format date in Calculated Field.. Calculated field uses Excel formulas (not all of them are available).. But fortunately you have TEXT function which can be used to format dates in Calculated Columns..

For example:

TEXT([Created], "dd.MM.yyyy")

Please see TEXT Function for reference

PS: Its better to try your formula in Excel before using it in SharePoint

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.