Find last edited date for any page

Question

hello,

I want to find all pages that haven't been edited since before March 2013.

I've tried using modified:[03/01/10 TO 03/01/13]

but this doesn't yield any results at all. I've tried other variations of this. These either fail because the syntax is incorrect or they return no results.

Am I doing this right or is there another way of finding this info?

We're running Confluence 4.3.7 locally.

Cheers.

Septa Cahyadiputra · Answer

Also, you need to add condition

WHERE PREVVER IS NULL

to ensure the query return only the current page instead of the old versions

T I1 · Answer

Try modified:[yyyyMMdd TO yyyyMMdd]