I am writing a filter for an XML data connection to filter out status of Pending, employee of current employee and date (WeekEndingDetail) of < today. I got the status and the employee working, but I can not get the filter to work for the date (WeekEndingDetail). I am not sure if xDdate is the correct format or item to use. Thanks.
public void Search_Clicked(object sender, ClickedEventArgs e)
{SetUserNameOptions(); }private void SetUserNameOptions(){FileQueryConnection q = (FileQueryConnection)this.DataConnections["AllocDetail xml filter"];q.FileLocation = q.FileLocation + "&FilterField1=Status&FilterValue1=Pending&FilterField2=Employee&FilterValue2=" + GetUserNameValue() + "&FilterField3=WeekEndingDetail&FilterValue3<xdDate:Today()";q.Execute();}private string GetUserNameValue(){XPathNavigator nav = this.CreateNavigator();string filterValue = (string)nav.SelectSingleNode("/my:myFields/my:QueryAllocDetail/my:AllocDetail/my:Employee", this.NamespaceManager).ValueAs(typeof(string));return filterValue;}