Under Review

Query Changes In User Directory

##Set date as variable date and choose a timestamp:

SELECT filename,

       (size / 1024) AS Kb,

       path,

       datetime(mtime,'unixepoch','localtime') Modifiedtime

FROM file

WHERE (Modifiedtime > $$date$$ AND filename != '.')

      AND (path LIKE 'C:\Users\%\%\%'

      OR path LIKE 'C:\Users\%\%')

This will look for C:\Users\%USERNAME%\%FOLDER% and C:\Users\%USERNAME%\%FOLDER%\%FOLDER%