The Student Room Group

Notion databases

Basically, I'm making my own Notion template
and I want a separate table for lectures that I'm behind on, starting from last week and earlier.
I’ve only figured out how to make a filter that shows lectures from “the past x weeks.” It kind of works, but it shows lectures as late starting from the day before, not a full week ago.

yeah so help please
To fix this, add a Date property to your table. Then, set a filter with the condition “Date is on or before” “Last Monday” (or your chosen start day). This will show only lectures from a full week ago or earlier, avoiding the issue of showing recent days.
Reply 2
Original post by Stephen65
To fix this, add a Date property to your table. Then, set a filter with the condition “Date is on or before” “Last Monday” (or your chosen start day). This will show only lectures from a full week ago or earlier, avoiding the issue of showing recent days.

so do i have to change the filter each week so that its from the last monday? because these are the only options i get (in the pic). or is there a way to make it so that the custon date isnt fixed and updates by itself with each week? (thank you btw)

Quick Reply