0 Replies Latest reply: Jul 8, 2018 9:48 AM by Jyotiranjan Nath RSS

    Need to create  Season by using some Months

    Jyotiranjan Nath

      Hi All,

      I have a requirement to create Season field in back-end, so that we can use this field as filter in front end.

       

       

      Season
      WinterJun,Jul,Aug,Sep of current yearIf we select Winter from season filter it should display data of these months of current year
      SummerFeb,Mar,Apr,May of current year
      MarketingCurrent Year Winter+Previous Year Summer
      ShippingOct,Nov,Dec of Current Year+Jan to Sep of next year

      Sample Data

      ------------------ 

       

      CropRegionYearMonthMonthYearSales
      CornNA2017JanJan-1710
      CornNA2017FebFeb-1720
      CornNA2017MarMar-1730
      CornNA2017AprApr-1740
      CornNA2017MayMay-1750
      CornNA2017JunJun-1760
      CornNA2017JulJul-1770
      CornNA2017AugAug-1780
      CornNA2017SepSep-1790
      CornNA2017OctOct-17100
      CornNA2017NovNov-17110
      CornNA2017DecDec-17120
      SoybeanNA2017JanJan-1715
      CornAPAC2017DecDec-17120
      CornNA2018JanJan-1810
      CornNA2018FebFeb-1820
      CornNA2018MarMar-1830
      CornNA2018AprApr-1840
      CornNA2018MayMay-1850
      CornNA2018JunJun-1860
      CornNA2018JulJul-1870
      CornNA2018AugAug-1880
      CornNA2018SepSep-1890
      CornNA2018OctOct-18100
      CornNA2018NovNov-18110
      CornNA2018DecDec-18120
      SoybeanNA2018JanJan-1815
      CornAPAC2018DecDec-18120

       

       

      Thanks