/bundles/itninjaweb/img/Breadcrumb_cap_w.png
I'd like to get a report that shows our knowledge base articles that have not been modified in the previous 6 months.  This way we can review the KB's to see if they are still relevant and up to date.  After reviewing previous posts I can get a list of KB names using SELECT ADVISORY.TITLE but I'm not sure how to incorporate the last modified date.
Answer Summary:
Cancel
0 Comments   [ - ] Hide Comments

Comments

  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
Please log in to comment

Answer Chosen by the Author


Answers

0
Try this:

SELECT id,title, category, modified 
FROM ADVISORY
WHERE modified <= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
Answered 05/16/2018 by: Druis
Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Answers