I would like to create variables like current week and last week but the value of the variable should be calculated. How to do this??
Thanks for help.
here you go:
vCurWeek: Put this in the Value field =Week(Today())
Agree with Rainer, but if want more a format with the year inside, just use WeekName() instead of Week() function.
vCurWeek : =WeekName(Today())
vLastWeek : =WeekName(Today()-7)
Thanks a lot.
And, if you want to represent it as the date of week start:=weekstart(today())=weekstart(today()-7)Similar for week end. The possibilities are endless.
Retrieving data ...