1 Reply Latest reply on Oct 13, 2017 6:14 AM by Jim Dehner

    Date Comparision from day of current week, day of previous week, day of previous to previous week.

    rohit chourasia

      For a date that is selected, Let suppose 10/13/2017 is selected which is a friday, give me data for previous 2 friday as well.

      ie 10/6/2017 and 9/29/2017. So that i can compare data for day of current week, day of previous week, day of previous to previous week.

        • 1. Re: Date Comparision from day of current week, day of previous week, day of previous to previous week.
          Jim Dehner

          Hi

          not sure how you want to do the the compaison or select the date but if you have a "date parameter' to select the date and a field named Date

          the first date is          Date=[date Parameter)

          The date 7 days ago is Date = Dateadd('day',-7,[date parameter])

          The date 14 days ago is date = Dateadd('day',-14,[date parameter])

           

          you can tie themn together in boolean type filter like

          Date=[date Parameter)  OR  Date = Dateadd('day',-7,[date parameter]) or date = Dateadd('day',-14,[date parameter])

           

           

          And set it on the filter shelf and set it to True

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.