SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

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

share|improve this answer

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

share|improve this answer
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. – Sven Gillis Dec 12 '12 at 16:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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