REVIEWED by Sophos
This query will list all the software installed between two dates, taking Sophos out of the list. The variable screen is below. It also shows the format. Some software has no date so that is returned just in case it helps
SELECT name, version, publisher, install_date,
install_location AS 'Install Path'
WHERE NAME NOT LIKE 'Sophos%'
OR install_date = ''
AND install_date >= '$$StartDate$$'
AND install_date <= '$$EndDate$$'
ORDER BY install_date DESC
This what the result looks like