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...
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 

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