Same week last year

[Anonymous]

Hi guys,

I've got two variables in a load script

Let vWeekStart = WeekStart(today())

Let vWeekEnd = WeekEnd(today())

What I would like to do is create the same variables for the same week last year

Can this be done?

Thanks
Mel

[tomasz_tru]

Week numer can be tricky, first you have to decide what kind of week number you want - to make sure you have everything under control: Redefining the Week Numbers

Tomasz

[jmvilaplanap · Accepted solution]

Hi,

Could you try:

LET vWeekStartPrevYear = weekstart(addyears(today(), -1)

LET vWeekEndPrevYear = weekend(addyears(today(), -1)

Regards