Find last edited date for any page

[Mick Davidson]

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.

[T I]

Try modified:[yyyyMMdd TO yyyyMMdd]

[Septa Cahyadiputra]

Also, you need to add condition

WHERE PREVVER IS NULL

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