Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group Calendar Date by Last 7 Week Days Dynamically Calculate column

Hi Need to group dates into last 7 days of my calendar table in a column, I tryied with out luck and finally llooks I´m very close with this calculated column: First Day 7 Last Days = VAR toda...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, thanks but does not work either.

This solution evaluates today and puts and Y if it´s in the last 7 days.

I need to put there max of week start in 7 days rolling periods.

from today to today -6 --> todays date

from day 6 to 14 --> day 6 date

from day 15 to 21 --> day 15 date

etc...

Thanks in advance