Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps this?
DATE = '>=$(=WeekStart(AddYears(Today()-6, -1))) <=$(=Date(WeekEnd(AddYears(Today(), -1))-7))'
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.
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))))'