Discussions

Expand all | Collapse all

I need help with a formula to change date to text, isolating the month

  • 1.  I need help with a formula to change date to text, isolating the month

    Posted 03-13-2018 12:50


  • 2.  RE: I need help with a formula to change date to text, isolating the month

    Posted 03-13-2018 12:52
    Please give an example of a date and the result that you want to achieve.  For example, today is March 13, 2018.  What is the text result you are looking for?


  • 3.  RE: I need help with a formula to change date to text, isolating the month

    Posted 03-13-2018 12:53
    I want 3-13-2018 to read "March


  • 4.  RE: I need help with a formula to change date to text, isolating the month

    Posted 03-13-2018 12:53

    Not sure why it didn't post the rest but I'm trying to transfer the numeric date into another field, isolating the month as a word instead of a number. I scrolled through several pages in the forum and didn't see a way to do this so I apologize if it's somewhere else.

    Thanks!



  • 5.  RE: I need help with a formula to change date to text, isolating the month

    Posted 03-13-2018 12:58
    Try this


    Case(Month([my date field goes here]),
    1, "January",
    2, "February",
    3, "March",
    4, "April",
    5, "May",
    6, "June",
    7, "July",
    8,"August",
    9,"September",
    10,"October",
    11,"November",
    12,"December")


  • 6.  RE: I need help with a formula to change date to text, isolating the month

    Posted 03-13-2018 13:08
    That worked! Thank you so much!!