0

monthName not working ... bug?

I have two fields for the start date of our school term and our end date. For our invoices, I am pulling that data via a function with the code below and it works.

'Term Start Date') + " & " + 'Term End Date'

What I really want is to just display the months via monthName with the code below but for some reason, I get a blank for the first date and the wrong month for the second date.

monthName('Term Start Date') + " & " + monthName('Term End Date')

I'm feeling silly for not being able to get this simple thing working. Any idea what I am doing wrong or if this is a bug?

4 replies

null
    • Halio
    • Halio
    • 5 yrs ago
    • Reported - view

    So this other method (below) worked but it still doesn't explain the oddity of monthName not working.

    substring(text('Term Start Date'), 0, 3) + "-" + substring(text('Term End Date'), 0, 3)

    • Nick
    • 5 yrs ago
    • Reported - view

    Yep,

    month() gives the correct month number

    while

    monthName() gives always a month behind

    and

    for January gives nothing

    • Halio
    • Halio
    • 5 yrs ago
    • Reported - view

    That seems to me a bug or am I missing something about how this works?

    • Birger_H
    • 5 yrs ago
    • Reported - view

    Seems like a bug to me :-)
    This is the solution:
       monthName(month('Your Date Field'))

    Birger

Login to reply

Content aside

  • 5 yrs agoLast active
  • 4Replies
  • 958Views