3 Replies Latest reply on Apr 3, 2018 9:50 AM by Jim Dehner

    Week 1 of the year

    Tracey Linderman

      How do I get my week one to reflect the first full week of the year? With my week starting on Tuesday.

      WK 52 would have been 12/26/17 to 1/1/2018 and WK1 1/2/18 to 1/8/18

        • 1. Re: Week 1 of the year
          Ritesh Bisht

          Do you mean like this ?

          Screen Shot 2018-04-03 at 9.49.22 PM.png

           

          STEP 1

           

           

           

          Screen Shot 2018-04-03 at 9.51.59 PM.png

           

           

          then,

           

          Screen Shot 2018-04-03 at 9.49.37 PM.png

           

           

          STEP 2

           

          Screen Shot 2018-04-03 at 9.50.05 PM.png

           

          Drag

           

          Order Date-->Column

          Datename -->Rows

           

          &

           

          Both the FIXED calculations to Text

           

          STEP 3

           

          Filter on Datename as Tuesday

           

          Screen Shot 2018-04-03 at 9.54.00 PM.png

           

           

           

          If this post assists you to get to the solution then please mark it as HELPFUL and if it is the Solution that you are looking for then please mark it as CORRECT  so that it can help others as well.

           

          Thanks,

          Ritesh

          • 2. Re: Week 1 of the year
            Tracey Linderman

            Here is an image what my problem looks like. I need the first row to reflect the date range 12/26/17 to 1/1/18 and the second row to be 2018 W1 date range 1/2/18 to 1/8/18.

             

            • 3. Re: Week 1 of the year
              Jim Dehner

              Hi Tracey

               

              Have you tried using this calculated field for your date

               

               

              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.

              1 of 1 people found this helpful