1 Reply Latest reply on Aug 16, 2018 9:30 PM by Naveen B

    Create a last two weeks from last date in data set

    Alex Martino

      Hello. I have data that I update every two weeks. I have a tab that I want to show the last two weeks of data from final date in the data set. How can I do this?

        • 1. Re: Create a last two weeks from last date in data set
          Naveen B

          Hi Alex,

           

          Create a calculated field like below

           

          DATEDIFF('week',[Date Field],{MAX([Date Field])})<2

           

          Place it in filter and select true

           

          {MAX([Date Field])} - This will give the maximum date in your dataset

          [Date Field] - This will give all the dates in the dataset

           

          Hope this helps kindly mark this answer as correct or helpful so that it will be helpful to others

           

          BR,

          NB