Hi John S

Write this code in OnClick function.
This will give the records within the given date range.
This code is in C#..

string sQueryText = string.Empty;
       
string toid = getNodeValue("/dfs:myFields/my:Todate");
string fromid = getNodeValue("/dfs:myFields/my:Fromdate");

                         
sQueryText  = string.Format("select * from Table1 where name ='{0}' and date
between '{1}' ", toid, fromid);
ADOAdapter2 table1Adapter = (ADOAdapter2)
thisXDocument.DataAdapters["Table1"];
table1Adapter.Command = sQueryText;       
table1Adapter.Query();

I hope this will help U

I've put together a solution (see
http://enterprise-solutions.swits.net/infopath/filter-repeating-table-date-range
-rules.htm)
where you can specify two dates using date pickers and then use these dates
to filter records in a repeating table using nothing else but rules and
filters (no custom code).
---
S.Y.M. Wong-A-Ton