7 Replies Latest reply on Jul 27, 2016 1:34 PM by Joe Oppelt

    Date Color based on the current Fiscal Quarter

    Aman Chauhan

      I have data as shown below-

       

          

      NameDate
      Toby Shean11/18/15
      Lizbeth Marquez4/4/16
      Linda Pollack8/17/15
      Rudi Vermeulen8/17/15
      Benny Verhaeghe8/17/15
      Doug Molumby8/17/15

       

      Now I need to Check whether the 'Date' if falling before the 'Current Fiscal Quarter' ( which will change as per the report viewing date) or not.

      If its before the Current Fiscal quarter it should be marked as Green else it should be Orange as shown below-

       

      NameDate
      Toby Shean11/18/15
      Lizbeth Marquez4/4/16
      Linda Pollack8/17/15
      Rudi Vermeulen8/17/15
      Benny Verhaeghe8/17/15
      Doug Molumby8/17/15

       

      Can anyone please help?