1 Reply Latest reply on Oct 2, 2014 11:48 PM by Sankarmagesh Rajan

    How do I create a filter that controls two separate date filters?

    Sam Padrul

      I've got two columns, one uses created_at, and the other uses updated_at.  I want to be able to create a filter so that if I choose 10/1/2014, it will filter all results for where column 1 is created_at = 10/1/2014 and column 2 is updated at = 10/1/2014

        • 1. Re: How do I create a filter that controls two separate date filters?
          Sankarmagesh Rajan

          Hi Sam,

           

          Normally if we have got two date fields then this will not same for all dates.like your data created at and updated at is not same in all dates. if i create the data at 10/1/2014 then i ll modify same date or some other date.

          If you want to filter only the created at and updated at dates are the same then we can create calculated filed as

          Date and add the following in calc [created at] = [updated at] then apply to filter and select true.

           

          Now apply created at date as quick filter and try. now we can get same date created and updated data only.

           

          Thanks

          sankar