Last week current year vs Last week last year date

[bhawana]

Hi all,

I need to create last week this year vs last week last year date. I tried creating last weeks date which looks fine but unable to create last week last year date.

Date ranges from 2017 to 2019 .

DATE = '>=$(=WeekStart( Today()-6)) <=$(=Date(WeekEnd( Today())-7))'

Could anyone please help me?

Thanks in advance

[Anil_Babu_Samineni]

Perhaps this?

DATE = '>=$(=WeekStart(AddYears(Today()-6, -1))) <=$(=Date(WeekEnd(AddYears(Today(), -1))-7))'

[bhawana]

My last week ranges from 9/8/2019 -9/14/2019 and your last week last year ranges from 9/9/2018- 9/14/2015. OI am not sure why is this happening , 

Is there a better way to do last weeks date without using today -6 or today -7 ?

vMax=2019

vMin =2017 

Please help.

[StarinieriG]

Hi,

maybe instead of Today()-6 or Today()-7 you could use MakeWeekDate function

For example

DATE = '>=$(=Date(WeekStart(MakeWeekDate(Year(Today()),Week(Today())-1)))) <=$(=Date(WeekEnd(MakeWeekDate(Year(Today()),Week(Today())-1))))'