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.