InfoPath 2003 Query by Date Range

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

I found this article ( 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 (  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

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

    Accepted Solution

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now