What's the best method to filter portal records by current week?
I have a table which has rota information and the field Rota::WeekCommencing which stores the first date of every week in a year.
I want a portal which shows just the 1 record pertaining to every week.
So basically in short, every week should just have 1 record filtered by the current week commencing start date.
Any advice would be great, thanks!