Date Conversions/Calculated Fields - SP List

If you need to convert Article Date = '01/01/2013' to 'January 2013, you need to do the following

• Add a new column to SP List
• The type of the column is calculated.
• Insert this formula to get the desired out come. [=TEXT([Article Date],"mmmm")&" "&TEXT([Article Date],"yyyy")]

If you need to convert Article Date = '01/01/2013' to '01 January', you need to do the following:

• Follow steps 1&2
• =TEXT(MONTH([Article Date]),"00")&" "&TEXT([Article Date],"mmmm")