Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Matthias,
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)
Matthias,
here you go:
vCurWeek: Put this in the Value field =Week(Today())
vLastWeek: =Week(Today())-1
Right?
Rainer
Matthias,
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.