5 Replies Latest reply: Aug 21, 2013 12:36 PM by JDN RSS

    HFR ISSUE FOR MONTHS

    991847

      Hi Every body,

       

      I  have scenario like

       

      If it is mar2011 in first column(My pointer current point of view)

       

      mar----apr--May----Jun-----Jul-----Aug---Sep-----Oct----Nov----Dec----Jan----feb---Mar

      2011-2011-2011--2011--2011--2011-2011---2011----2011----2011---2012---2012--2012

       

      I have used range function and RELATIVE FUNCTION FOR CHANGING THE MONTHS

       

      IHAVE TAKEN ONLY  TWO COLUMNS IN MY REPORT FIRST COLUMN MAR AND NEXT COLUMN BY USING RANGE&RELATIVE FUNCTION OF CURRENT MONTH

       

      BUT YEAR IS THE PROBLEM IT S NOT UPDATING.

      HOW SHOULD I UPADATE YEAR ACCORDING TO THE MONTH