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

       

      Regards

      Sid