Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Month Format

I am trying to add the month into the report I am creating. I made a measure and have displayed it as a card. This is the formula for my measure. Report Month = FORMAT(MONTH(TODAY()),"mmmm"). However, the card is displaying January and not May.

Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    use this formula:

    Current Month Name = FORMAT(TODAY(),"mmmm")

    Format needs a real date, using MONTH is returning just an integer.


    Regards

    Tom 

3 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    use this formula:

    Current Month Name = FORMAT(TODAY(),"mmmm")

    Format needs a real date, using MONTH is returning just an integer.


    Regards

    Tom 

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      And a date of 5 is Thursday the 4th of January, 1900, which is why it was returning Jan

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi Anonymous

     

    Please try this instead. 

     

    Report Month = FORMAT(TODAY(),"MMMM")