My Slices formula is showing items from the 7th day ago onwards, but I want it to show items from today to 7 days ago, where am I going wrong? Sorry for my english.
([Data] <= (TODAY() - WEEKDAY(TODAY())) - 7)
I don’t understand what you mean to accomplish by including this function.
I don’t understand what distinction you’re making.
Maybe you’re saying that your slice includes items older than a certain date but you want items newer than that date? In case it’s helpful:
([Data] >= (TODAY() - WEEKDAY(TODAY())) - 7)
Maybe you’re saying that you have items with dates in the future that you want to exclude from the slice? In case it’s helpful:
AND([Date] >= TODAY() - 7, [Date] <= TODAY())
1 Like