2 Replies Latest reply: Jul 7, 2011 2:34 AM by Shumail Hussain RSS

    Type Mismatch Error on MonthEnd Function in Macro

    Shumail Hussain

      I am using below macro and getting type mismatch error on MonthEnd Fucntion while executing macro on onSelect Field Event Below is a Macro.

      sub Update_PrevMonth()

      Set v = ActiveDocument.Variables("PrevMonth")

      v.setcontent MonthName(MonthEnd(LoadDate_Active-Day(LoadDate_Active))), true

      end sub

       

      Can anyone please help?

       

      Regards

      Shumail Hussain

       

      Reference :http://community.qlik.com/message/83724#83724