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 achive this.Is it possible to do by Calculated Value property?
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.
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..
Please see TEXT Function for reference
PS: Its better to try your formula in Excel before using it in SharePoint