Thursday, 18 April 2013

SharePoint 2010 - When [Today] just isn't your day

Sometimes your SharePoint environment doesn't want to play ball with OOTB features, so if you like me have once had an issue with the [Today] option not working on list filters, here is the slower but successful way of getting it to work:

Create the view using CAML Query in SharePoint Designer 2010.

The CAML equivalent of [Today] is:
<Value Type="DateTime"><Today/></Value>

Or if you want to be a few days ahead or behind today

<Value Type="DateTime"><Today OffsetDays="-31"/></Value>

Cheers,
The Baretta

No comments:

Post a Comment