Topic
In the exported Document List Csv report, some documents are showing their Next Review Date as '01 Jan 0001'. However, in the site itself those same documents are showing the correct next review date. Example screenshots below:
1) Where the document 'GA_3.7.4_doc_001 Company Letterhead' is showing its Next Review Date as '01 Jan 0001' in the CSV report -
2) But the same document is showing the correct 'Next Review Date' in the tenant site -
Reason of the issue:
It seems that somehow there is no review entry in the backend Database (DB) for the affected documents showing the incorrect next review date. The behavior on the UI is that it will create a date on the fly, taking the current date/time + review date frequency (which is 12 months by default) and display that, and the Document List report defaults to showing "01 Jan 0001" when there is no entry in the review table in the DB.
Instructions
In this case, if no review entry exists in the DB for such documents, the only solution is to manually add these dates in the DB for the customer.
So, the workaround is that the user can go and override the review frequency on the document, and then set it back to what it used to be, or leave it as is, and it will cause an entry to be created in the DB, which will then show a date on the report.
This can be done via the field below:
