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

Reply 1

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

How The Student Room is moderated

To keep The Student Room safe for everyone, we moderate posts that are added to the site.