InfoPath 2003 Query by Date Range

Posted on 2009-04-23
Medium Priority
Last Modified: 2012-05-06
Hello Experts,

I found this article (http://enterprise-solutions.ikreate.nl/infopath2003/filter-repeating-table-date-range-rules.htm) on how to accomplish a date range parameter and was successful in replicating the example; however, I am trying to translate this to an existing InfoPath/Access query tool I've built.  To add to the complexity the current query contains wildcard functionality similar to what is described here (http://support.microsoft.com/kb/826992).  I have a few questions needing clarification:

1.  The date range methodology described in the above article results in an automatic query that renders results when both date range parameters are defined by the user, since my query is using a custom query event button to support wildcard, how do I incoporate these together into a single button with existing custom code already existing for wildcard?

2. The date format required by the date range functionality is "yyyy-mm-dd", European sytle.  Initially I thought I would simply change this to "mm-dd-yyyy" but it seem when I do this it somehow disables the dange range from working properly, how do I change the date format to "mm-dd-yyyy"?

Question by:ShadowIT
LVL 44

Expert Comment

ID: 24228885
Try changing the Regional and Language settings for Date in the Control Panel to mm-dd-yyyy

Accepted Solution

ShadowIT earned 0 total points
ID: 24276517
Thanks, I was able to resolve the date format issue myself...I still need assistance with #1.  Combining the wildcard functionality with date range.  

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question