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!