In SharePoint 2010, Inned to get items from a list based on a condition. Considering one of the fields to be 'EventDate' of type DateTime, the condition is:
(EventDate - 60 Days) <= Today <= (EventDate + 30Days).
Note that the values 60 and 30 are not static.
To rephrase it in words, I need to show the list item if the event occurs 60 days from today or has occurred 30 days from today.
Hence, I need a rolling window on the EventDate. The OffsetDate attribute on Today element in CAML provides a rolling window on the Current date. Is it possible to achieve this in CAML? If not how do I filter the list items based on this condition ?