7 Replies Latest reply: Aug 22, 2014 4:12 AM by Staffan Johansson RSS

    YearWeek -1

    Staffan Johansson

      Hi,

       

      I have a YearWeek field 201401 (YYYYWW) if I want to step 1 week back i'll get 201400.

      I have test with two different:

      Dual(WeekYear(Date)&'W'&num(Week(Date),00),WeekYear(Date)&num(Week(Date),00)) as [Year Week],

      num(WeekYear(Date)&num(Week(Date),00)) as [Year Week Num],

      These are numeric and thats why I get 201400, but how to get the YerWeek field as a date so it will show 201352?

      I will use the field in a set analysis.