Skip to main content
Question

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

  • March 13, 2018
  • 0 replies
  • 31 views
I need help with a formula to change date to text, isolating the month
      This topic has been closed for replies.

      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?
      • EmilyHill
      • Author
      • Registered
      • March 13, 2018
      I want 3-13-2018 to read "March
      • EmilyHill
      • Author
      • Registered
      • March 13, 2018

      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!

      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")
      • EmilyHill
      • Author
      • Registered
      • March 13, 2018
      That worked! Thank you so much!!
      Terms & ConditionsAccessibility statement