4 Replies Latest reply on May 1, 2018 3:03 PM by Hari Ankem

    Filtering Using "OR" for 2 Date Fields

    Kevin Tsui

      Hi.  I have a filtering problem that I'd like some help with...  Here's some info:

       

      • Data set with 2 date fields
      • Want to filter the data to show only if either of the date fields fall within the current quarter

       

      For example, I have Date Field A and Date Field B.  Current quarter date range is 4/1/18 to 6/30/18.

       

      DataDate Field ADate Field B
      ABC1/1/182/1/18
      DEF4/2/182/1/18
      GHI1/1/185/2/18

       

      I would like to see "DEF" and "GHI" after I create a filter that says "show data if 'Date Field A' OR 'Date Field B' are 'This Quarter'".  How do I create that filter?  Thanks.