topic Re: week subtraction in Visualization and Usability

week subtraction

Thu, 13 Oct 2016 07:00:31 GMT

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

Re: week subtraction

robert_mika — Thu, 13 Oct 2016 08:15:19 GMT

To subtract use

Right(yourfield,2)

if the format is always the same.

Re: week subtraction

antoniotiman — Thu, 13 Oct 2016 08:39:39 GMT

Hi,

may be

WeekName(MakeWeekDate(Left(YearWeek,4),Mid(YearWeek,5)),-13)

Regards,

Antonio

Re: week subtraction

Thu, 13 Oct 2016 08:47:44 GMT

in the above scenario, what will happen if the week is first ,

say we have data from 201401 to 201501.

if i minus from 201501 , it will show me incorrect?

How to deal with this?