We have multiple documents(not stored in SharePoint) for which we monitor the review dates in SharePoint as a part of our document management system.
The information of document is stored in a list. We have multiple columns in that list.
Two of the columns are of type date: Last review date and Next Review date.
I would like to create a view that shows:
- Documents due for review in the next 60 days based on the last review date.
- Documents that don't have a review date (We have documents that are draft and therefore don't have a last review date).
Any help appreciated or suggestions.