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


      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.