3 Replies Latest reply: Oct 13, 2016 4:47 AM by khushboo Peswani RSS

    week subtraction

    khushboo Peswani

      Hi Team,

       

      I have data at yearweek level.

       

      say 201513 which is 13th week for 2015 year.

       

      I want to substract weeks from this . I know it is incorrect to use max(YearWeek)-13. 

       

      Also i know it would have been better to use dual while week creation. but this weeks are already present in the DB ( they have 445 calendar concept).

       

      What is the best way to do it at week level.

       

       

      Thanks

      Khushboo