Hi Guys, I have to created a custom view in code which will be filtered on Date is Equal/Greater than today's date.
This is my query string dt = "[Today]" string query = "<Where><Geq><FieldRef Name=\"HolidayDate\"/>" + "<Value Type=\"DateTime\">" + dt + "</Value></Geq></Where>"; This runs fine, and I can see the filter properly set up in the UI. But this does not work. It only works if I edit the view and just click Save without doing anything. string dt = "Today" , works but then it writes the filter value as today's date not as dynamic field. If I create a filter which is not based on dynamic value, that it works without problem. The dynamic [Today], requires me to save it again and then Moss applies the filter Please advise Here is the complete code. StringCollection viewFields = new StringCollection(); viewFields.Add("Title"); viewFields.Add("Date"); const string orderByColumn = "FileLeafRef"; string tName = "[Today]"; // string dateT = Microsoft.SharePoint.Utilities.SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Today.AddDays(1)); string query = "<Where><Geq><FieldRef Name=\"Date\"/>" + "<Value Type=\"DateTime\">" + dateT + "</Value></Geq></Where>"; // here you can filter your items using the selected item in the dropdownlist oViewCollection.Add(strViewName, viewFields, query, 100, true, isDefault); oWeb.Update(); oList.Update();
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss