Hello,
i need your support.
I have to calculate values of the previous week from a period that the user can define. (ex.1 Month, 1 week, 2 weeks or from day x to day y)
The calendar is built on this format date YYYYMMDD
I made this formula LastWeek = (PeriodTime Variable) - 7
It works if user takes as reference a day of 2nd, 3rd, 4rd week. The problem is when i select day/s from the 1rst week.
Here some screen --> selected period
In the previous week formula
Changing month, format goes to week format. Why?