1 Reply Latest reply on Jul 24, 2017 3:24 PM by swaroop.gantela

    Week of filter from Start & End Date Columns

    Luigi Cicciari

      Hello,

       

      In my data set I have a Start Date and End Date. I'd like to create a week of filter for all weeks within the range of those dates.

       

      For example, my Start Date is 7/3 and End Date is 7/30 (4 weeks). I'd like to create a field that lets me choose a week of between that range (e.g. 7/3, 7/10, 7/17, 7/24).

       

      In the attached, filtering for Week of 7/10 would filter out row 3 (7/3 - 7/9).

       

      Thanks in advance for any ideas.

       

      Luigi