9 Replies Latest reply: Jan 23, 2017 10:54 AM by Sunny Talwar RSS

    Addmonths function with a negative integer

    Ibrahim UYAR

      Hi all,

       

      I'm trying to change the start date of periods from 1st day of month to 26th day of previous month.

      For example, For December 2016 Period, it should be between November 26, 2016 and December 25,  2017

       

      When I'm trying to load below, qlikview does not subtract a month but adds it.

       

      Date(AddMonths(MonthStart(FiscalDate+25),-1), 'YYYY-MM') as Period


      Could you please help me to solve this?