9 Replies Latest reply on Oct 14, 2019 10:00 PM by sampath kumar

    How to display week numbers?

    sampath kumar

      Hi All,


      1.) Requirement - I have data to display Weekly wise irrespective of any given month. To display Mahfooj Khan

      Week 1

      Week 2

      Week 3

      Week 4

      Week 5


      I used below calculation


      {FIXED YEAR([Date]),MONTH([Date]):MIN(DATEPART('week',[Date]))}


      2nd calculation:


      CASE DATEPART('week',[Date])

      WHEN [Min week] THEN "Week1"

      WHEN [Min week]+1 THEN "Week2"

      WHEN [Min week]+2 THEN "Week3"

      WHEN [Min week]+3 THEN "Week4"

      WHEN [Min week]+4 THEN "Week5"

      WHEN [Min week]+5 THEN "Week6"