Skip to main content
Topics#Data ManagementLuke Siecinski's Question
Luke Siecinski (Form Technologies) asked in #Data Management
Oct 19, 2020, 10:01 PM

What formula to use to return the Month text string from a date field?

We have a date field called Received Date that we use to capture when one of our submissions came in. I'm trying to create a formula field that will return just the month of the received date and prefferably not the numeral value. So if it Received Date is 10/19/2020, I need the formula to return 'October'. 

 

I've tried using TEXT(MONTH(Received_Date__c)) but receive the error Error: Formula result is data type (Text), incompatible with expected data type (Date). I'm not sure how to convert a Date field to Text.
8 answers
  1. Karan Kehar (Acxiom)
    Oct 19, 2020, 10:05 PM
    Hey Luke

     

    Try this

     

    CASE(MONTH( DATEVALUE( CreatedDate )),

     

    1, ‘January’,

     

    2, ‘February’,

     

    3, ‘March’,

     

    4, ‘April’,

     

    5, ‘May’,

     

    6, ‘June’,

     

    7, ‘July’,

     

    8, ‘August’,

     

    9, ‘September’,

     

    10, ‘October’,

     

    11, ‘November’,

     

    12, ‘December’,

     

    ‘None’)
Write an answer...
0/9000