Applying filters on portal records

Discussion created by on Oct 10, 2016
Latest reply on Oct 11, 2016 by

Hello Everyone.


I need help with applying filters to a portal records.


I have activities sheet with date and time. I was trying to search for portal records based on time range. The part I am struggling on is filter activities in "Last 7 days" or "Last 30 days".


I tried using case statements for example if "period selected = "Last 7 Days " than go to table and field, get current date and do - 7. But this case statement does not work.


So how we can apply if/else or case statements in portal to filter records.