2 Replies Latest reply: Mar 25, 2015 3:02 AM by anbu cheliyan RSS

    Week Logic Requirement..............???

    AVIRAL NAG
      Dear All
      I need to Categorize the Weeks for every month as Week1, Wee2,.........
       
      If I use this:
      'Week'&Ceil(Day(New_Date)/7) as  Weeks
      than i am getting the Weeks as Week1, Week2,......
      but the problem with this is it is calculating the Weeks as Week1 =  1-7, Week2 = 8-14..................
      I don't want this.
      I want to calculate Weeks as: Suppose take a example for January 2015 than:
      Week1 = Thu, Fri, Sat, Sun (1,2,3,4)
      Week1 = Mon, Tues, Wed, Thu, Fri, Sat, Sun (5,6,7,8,9,10,11)............................
      Please find the enclosed Sample File for reference.
      Regards
      Av7eN