I need to display top X last modified documents and/or publishing pages. They need to be grouped by modified date. As far as I know, the CQWP does not support grouping by date. Is there a workaround available? I guess we need to manipulate the dates before the XSL is called. Someone already encountered this issue?


30 November 2012

Item a

Item b

16 November 2012

Item c

Item d

2 Answers 2


It could be accomplished with Calculated field as were suggested before.


  • Create calculated column for Modified date using the formula as shown on picture below

enter image description here

  • Specify this field in Grouping setting for CQWP

enter image description here


Have you tried with a calculated column from your original date field?

  • No, not yet. Thanks for mentioning. If client absolutely wants to group by like this - it's probably better to create a custom webpart it seems. Dec 12, 2012 at 16:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.