3 Replies Latest reply on Sep 27, 2013 1:06 AM by Kasper Ulvedal

    Comparing Dates (Months) in Filters with the 'And' or '='

    Siddharth Surana

      Hey Tab Pro's


      I have a data source which has two different files merged into one and both the files have separate data. My question is, I want to have a filter on the sheet whereby I compare dates like this:


      Month (Date) = Month (Campaign End Date)


      Can I calculate and compare the two dates ? I am trying to create a filter and within it make a calculate field to compare dates and publish results only if the condition is satisfied


      Got stuck with this here at work and trying to solve to the earliest


      Please help