Putting Month name from date field onto Exact Form

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a date field in Quickbase that on my Exact Form I would like to display ONLY the name of the month from.  So for example the date field "Due Date" has a value "5/1/2017", and on the Exact form I want it to say "May"

How can I do this?

Thanks,
Mike.
Photo of Mike

Mike

  • 402 Points 250 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
You can make a new field called month and use that on the form.


Case(Month($MyDate),
1,"JAN",
2,"FEB",
3,"MAR",
4,"APR",
5,"MAY",
6,"JUN",
7,"JUL",
8,"AUG",
9,"SEP",
10,"OCT",
11,"NOV",
12,"DEC")
Photo of Mike

Mike

  • 402 Points 250 badge 2x thumb
That worked perfectly!  Thank you! :) We couldn't work out how to do it in a field so had guessed it would need to be coded into the Exact form somehow, but that works really well.