Scenario:
Solution:
SPQuery Zindabad, I mean SPQuery is the best :-)
Also few things to note are
1. IncludeTimeValue="True"
2. SPUtility.CreateISO8601DateTimeFromSystemDateTime method
Code:
SPList list = web.Lists["Shared Documents"]; SPQuery query = new SPQuery(); string timeFrame = SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Now.AddDays(-7)); // Build our query. Note the use of IncludeTimeValue="True" to check against time query.Query = @" <Where> <Gt> <FieldRef Name=""LastPageHitTime"" /> <Value IncludeTimeValue=""TRUE"" Type=""DateTime"">" + timeFrame + @"</Value> </Gt> </Where>"; SPListItemCollection items = list.GetItems(query);
0 comments:
Post a Comment