Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 2 down vote favorite

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?

Example

30 November 2012

Item a

Item b

16 November 2012

Item c

Item d

share|improve this question

2 Answers

up vote 2 down vote accepted

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

Steps:

  • 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
up vote 0 down vote

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

 
discard

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.