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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Photo of Emily Hill

Emily Hill

  • 172 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,634 Points 50k badge 2x thumb
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?
(Edited)
Photo of Emily Hill

Emily Hill

  • 172 Points 100 badge 2x thumb

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!

Photo of Emily Hill

Emily Hill

  • 172 Points 100 badge 2x thumb
I want 3-13-2018 to read "March"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,634 Points 50k badge 2x thumb
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")
Photo of Emily Hill

Emily Hill

  • 172 Points 100 badge 2x thumb
That worked! Thank you so much!!