5 Replies Latest reply on Oct 15, 2015 11:46 PM by user19752

    Filter Portal Records By Week

      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!