Make a date field with only the month - no day or year

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I want to create a date field that will only display the month. I tried using a text field but the filter then displays alphabetically instead of January, February, etc. 

Photo of Chris

Chris

  • 60 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
Low tech

Right("0" & totext(month([my date field]),2)

That should return the month numbers like

01

02

03

...

12

If you want the words and they need to sort properly , then you will need to suffix the words to a prefix to sort.

Case(Month($MyDate),
1,"01-JAN",
2,"02-FEB",
3,"03-MAR",
4,"04-APR",
5,"05-MAY",
6,"06-JUN",
7,"07-JUL",
8,"08-AUG",
9,"09-SEP",
10,"10-OCT",
11,"11-NOV",
12,"12-DEC"))
Photo of Chris

Chris

  • 60 Points
Thank You!