The <today/> tag not working in my CAML Query?

Question

I am trying to retrieve the 5 most upcoming (with respect to expiry date) announcement list item "Title's".The query partly works but what it fails to do is include and display todays announcements as well (For ex: Announcements posted earlier in the morning).

I looked around the net and all of that suggests adding the IncludeTimeValue='TRUE' in the tag, but it still does not work. What am I missing? I have also tried using the <now/>.

Answer 1

Unless you're sure that all the announcements you want has an Expire datetime then you're missing an "or+isnull" like this:

<Query>
 <Where>
  <And>
   <IsNotNull>
    <FieldRef Name="Title" />
   </IsNotNull>
   <Or>
    <IsNull>
     <FieldRef Name="Expires" />
    </IsNull>
    <Geq>
     <FieldRef Name="Expires" />
     <Value IncludeTimeValue="TRUE" Type="DateTime">
      <Today />
     </Value>
    </Geq>
   </Or>
  </And>
 </Where>
 <OrderBy>
  <FieldRef Name="Expires" Ascending="True" />
 </OrderBy>
</Query>

Answer 2

Partly answered:

I just used the date and not the datetime. Since it was just announcements I didn't mind it being on the page for an extra day. The default expires field only holds the data value anyway. A simple <geq> on the Expires field with type="Date" did it for me.

Answer 3

I set up some announcements exactly like what you have in the screen shot. I did not get correct results in my view until I, for some reason, included the Expires field in the ViewFields element.

<View Name="{5613B6A8-3D6D-40B0-9597-8CDBD9DD92AC}" Type="HTML" DisplayName="TodayOrLater" Url="/teams/root/it/Lists/Announcements/TodayOrLater.aspx" Level="1" BaseViewID="1" ContentTypeID="0x" ImageUrl="/_layouts/images/announce.png">
                <Query>
                    <Where>
                        <And>
                            <IsNotNull>
                                <FieldRef Name="Title"/>
                            </IsNotNull>
                            <Geq>
                                <FieldRef Name="Expires"/>
                                <Value Type="DateTime">
                                    <Today/>
                                </Value>
                            </Geq>
                        </And>
                    </Where>
                </Query>
                <ViewFields>
                    <FieldRef Name="Attachments"/>
                    <FieldRef Name="LinkTitle"/>
                    <FieldRef Name="Modified"/>
                    <FieldRef Name="Expires"/>
                </ViewFields>
                <RowLimit Paged="TRUE">30</RowLimit>
                <Aggregations Value="Off"/>
                <Toolbar Type="Standard"/>
            </View>