We always prefer “Pause until Date” in SharePoint Designer workflow to delete the items or to hide the items after 90 days. In this post, I will show you how to hide the items without using SharePoint designer workflow.
- Create a Calculated column in list (Say, Is90days) with the formula, =Created+90 with Date as return type as shown below
- Create a standard view called, Myview with the below filters
- CreatedBy=[Me] to show only their items.
- Is90days>=[Today] to show the items only till 90 days from the creation date.
NOTE: If you have sensitive data and you are afraid that they might switch the view to see all the items, you may target the audience for the list web part with all the items.