3 Replies Latest reply: Aug 2, 2018 2:03 PM by Elizabeth Viso RSS

    Previous Month Expression

    Elizabeth Viso

      I currently have this expression:

       

      =Date(Max(MakeDate(2018,MonthNum,1)),'MMM') & ' ' & Max(Year)

       

      Which shows me the current month and year, but what do I need to add to give me the previous month? I tried adding -1 but that isn't working. Thank you!