Filter Portal Records By Week

Discussion created by disabled_kylerjphillips on Oct 14, 2015
Latest reply on Oct 15, 2015 by user19752

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!