How to query between date range

[Paul Mayer]

I have a primary data connection in my infopath form. I want to query
between a date range. I have a field in the database called CompletedDate as
a date field. I have defined MyStartDate and MYEndDate as date fields, these
feilds are not included in the database. How do I get the infopath form to
return result between MyStartDate and MyEndDate?

 

[Clay Fox]

Hi Paul.

This is tougher since, as you have found, standard query functionality does
not support this.

I have seen a way to use an xml and pass a variable to the SQL query in your
data connection. This was discussed on http://www.infopathdev.com

Best practice is to use a web service. With that you can do dynamic queries
as you describe not only on your Primary but any secondary data connections
too. You can also use web services to submit your data back to SQL and
update whatever tables you want. With a database type form you are bound to
a set of rules on what you can and cannot do with your data connections, web
services frees you from those rules.
I would suggest you check out the Database Accelerator package at
http://www.qdabra.com This is a package of the webservices I have described
that is installable on your SQL server and ready to go. You can interact with
your data without code and be able to perform dynamic queries and submits.

 

[Paul Mayer]

Clay:

Will the Database Accelerator package work with Microsoft Access 2003
databases. I am using Infopath 2003 for my application development.

 

[Clay Fox]

No, but you can make a free upgrade to SQL Express.

InfoPath 2003 is not a problem.

 

[Clay Fox]

If you would like to discuss this further Paul, you can email me from here.
http://www.infopathdev.com/members/clayfox.aspx

 

[S.Y.M. Wong-A-Ton]

Try this article:
http://enterprise-solutions.swits.net/infopath2003/filter-repeating-table-date-range-rules.htm