Query by Dates

[Shannon]

I have an infopath form attached to an access database. One of the things I
use the database for is storing review dates for employees. I was wondering
if there was anyway to search for open ended dates; say I wanted to serch for
everyone that had a review in March, it seems I can't run a query simply
using 03/**/**** to get anyone in March. Is there another way to search for
this or would I have to make a seperate field for month, day, and year in
order to search by month?

Thanks!

 

[Clay Fox]

Unfortunately the basic database functionality is rather limited as you have
found.
InfoPath was designed to use web services to get all of the functionality.
That will allow you to do full dynamic queries like you describe.

It is possible to use code to query as well.

You could get it possibly by creating seperate fields in your database and
form or you have to load all records and then use a filter to display just
the dates you want.

If you are interested in adding web services you can get them as an
installable package.
Email me if you would like to know more.
http://www.infopathdev.com/members/clayfox.aspx

 

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

You could search on a date range as in this article:
http://enterprise-solutions.swits.net/infopath2003/filter-repeating-table-date-range-rules.htm