Discussions

Expand all | Collapse all

Putting Month name from date field onto Exact Form

  • 1.  Putting Month name from date field onto Exact Form

    Posted 06-20-2017 18:14
    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.


  • 2.  RE: Putting Month name from date field onto Exact Form

    Posted 06-20-2017 18:17
    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")


  • 3.  RE: Putting Month name from date field onto Exact Form

    Posted 06-20-2017 18:40
    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.