2 Replies Latest reply: Jul 25, 2016 2:34 PM by Clauria Yang RSS

    Month function returns month number instead of the month name?

    Clauria Yang

      Hello,

       

      I have an expression:

      month(addmonths(MakeDate(1900,month(date#((GetFieldSelections([Month])),'MMM')),1),-1))

       

      The Month field is the three-letter month name. What i want is to getthe month name of last month. The expression gives me the correct month number in integer. Shouldn't month()  return a month name?

       

      Please help.

       

      Thank you.