4 Replies Latest reply on Oct 2, 2018 3:00 PM by Michael Ye

    Set Date to 'WeekEnding' (Mon-Sun) with week ending date

    Arno Grigorian

      Hi,

       

      I am trying to create a new 'WeekEnding' metric that will set 'Day Date' week to run from Mon-Sun. while also showing week ending date.

      I have tried using the following formula but it is showing me week beginning dates for the Mon-Sun period: DATEADD('day',1,DATETRUNC('week',DATEADD('day',-1,[Day Date])))

       

      Example:

      Day Date     WeekEnding          Day

      9/17/18          9/23/18               Monday

      9/18/18          9/23/18               Tuesday

      9/19/18          9/23/18               Wednesday

      9/20/18          9/23/18               Thursday

      9/21/18          9/23/18               Friday

      9/22/18          9/23/18               Saturday

      9/23/18          9/23/18               Sunday    

      9/24/18          9/30/18               Monday

      9/25/18          9/30/18               Tuesday

      9/26/18          9/30/18               Wednesday

      9/27/18          9/30/18               Thursday

      9/28/18          9/30/18               Friday

      9/29/18          9/30/18               Saturday

      9/30/18          9/30/18               Sunday

       

      Thank you