Hello I'm looking for a tool or a macro which shows me the pages created/modified during the last week/month/day etc. The velocity code I found on the Recenty+Modified page would be fine, if I could filter the SQL by date. How is it to be done? "where 1=1 and doc.creationDate="2007-10-17" order by doc.creationDate desc" didn't work. What is the right syntax? Regars, Tamas