Sort page properties report macro by created date

[Angus Law]

Is it possible to sort by date of creation on the Page Properties Report macro? The pages are very difficult to keep track of as the current default is "last modified date"

[Davin Studer · Accepted solution]

This should work for you. Create a user macro using the code below. It will take the create date and output it in yyyy-MM-dd format so that it is sortable (the report macro does string sorting, so other formats of the date won't work). Then add another property to the page properties macros called Created, or some such thing, and include this user macro in the right column. Then in your report macro have it sort on the Created property.

## Developed by: Davin Studer
## Date created: 12/04/2014
## @noparams

$action.dateFormatter.formatGivenString("yyyy-MM-dd", $content.getCreationDate())

[Angus Law]

Thanks Davin - I assume that it's not possible normally hence the workaround!

[Davin Studer]

Correct. There is no native way in the report macro to do it.

[Angus Law]

Nightmare