Forum Discussion

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
7 years ago
Solved

LastMonth

I want to show last month from today. I have this measure but instead of February it's showing January. Any idea?   LastMonth = FORMAT(MONTH(TODAY()-1), "MMMM") <-- this shows January LastMonth...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    diskovered try this

     

    Last Month = FORMAT( EOMONTH( TODAY(), -1 ), "MMMM" )
  • parry2k's avatar
    parry2k
    7 years ago

    diskovered  yup

     

    Last Month = FORMAT( EOMONTH( TODAY(), -1 ), "MMMM, yyyy" )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

diskovered try this

 

Last Month = FORMAT( EOMONTH( TODAY(), -1 ), "MMMM" )
diskovered's avatar
diskovered
Icon for Helper III rankHelper III
7 years ago

parry2k Any way to add year? (February 2019? in the same code?

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    diskovered  yup

     

    Last Month = FORMAT( EOMONTH( TODAY(), -1 ), "MMMM, yyyy" )
    • diskovered's avatar
      diskovered
      Icon for Helper III rankHelper III
      7 years ago

      Thanks