AnsweredAssumed Answered

Problem with calculation producing incorrect data

Question asked by xxx202xxx on Jan 1, 2018
Latest reply on Jan 4, 2018 by user19752

My Calculation:

"Week of Sunday -"

&" "&

Let ( [D = Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) ) - 1 ) ; D1 = D - DayOfWeek ( D ) + 1] ; D1 + Dashboard_Management::c_Week * 7)

&"  Thru Saturday  "&

Let ( [D = Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) ) - 1 ) ; D1 = D - DayOfWeek ( D ) + 1] ; D1 + Dashboard_Management::c_Week * 7) + 6

 

Instead of producing Week of Sunday - 12/31/2017  Thru Saturday  1/6/2018 it is producing

Week of Sunday - 1/7/2018  Thru Saturday  1/13/2018.

 

Please Help

Outcomes