Please Note: This query only searches comments left within the last week or so
Q&A for committed Christians, experts in Christianity and those interested in learning more
SELECT Id AS [Comment Link], Score, CreationDate as Date FROM Comments WHERE text like '%##Word##%' AND CreationDate > '2014-08-10T00:00:00.000' ORDER BY CreationDate DESC