locked
Calculated Column: Get Month in letter with CHOOSE function "not supported" RRS feed

  • Question

  • Sharepoint 2007

    Hi all, 

    I'm trying to create a formula to get the month of a date in a column in letter, but the function doesn't work

     

    So can you help me?

     

    =CHOOSE(MONTH([Publication Date]),"January","Febrary","March","April","May","June","July","August","September","October","November","December")
    
    

     

    I tried this function:

     

    =CHOOSE(2,"January","Febrary","March","April","May","June","July","August","September","October","November","December")
    
    

     

    but it doesn't work too.

     

    Thanks in advance

     

    Julien Garcia Gonzalez

    • Edited by Mike Walsh FIN Tuesday, January 18, 2011 10:26 AM Sharepoint 2007, default here so removed from Title and put in text
    • Moved by Mike Walsh FIN Tuesday, January 18, 2011 10:27 AM std function so admin not customization (From:SharePoint - Design and Customization (pre-SharePoint 2010))
    Tuesday, January 18, 2011 10:10 AM

Answers

  • OK i found the "error", i just need to change the comma in semicolon.

     

    Depends of my locale!!

     

     

    • Marked as answer by Mike Walsh FIN Tuesday, January 18, 2011 11:15 AM
    Tuesday, January 18, 2011 10:15 AM