This content has been marked as final. Show 3 replies
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.