0

Display Formula as Month?

Is there a way to have the results of this formula appear as "January?"

Screen Shot 2020-02-17 at 5.48.31 PM

3 replies

null
    • Nick
    • 4 yrs ago
    • Reported - view

    format('Beginning Date', "MMMM")

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Thanks Nick. That works great.

    Oddly, the formula I used shown above, and shown in the manual as the way to do this, shows a result of the past month. If the begining date is Jan. 1 2020, the the formula result is empty. If the begining date is Feb. 1 2020, the the formula results is January. That is not correct.

    • Nick
    • 4 yrs ago
    • Reported - view

    You are welcome.

    I know what you mean, it shows me Sunday and Monday as a weekend rather than a Saturday and in a timed field with trigger on creation for the current time, it always gives 1 hour back.

Login to reply

Content aside

  • 4 yrs agoLast active
  • 3Replies
  • 867Views