• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 864
  • Last Modified:

InfoPath 2003 Query by Date Range

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"?

1 Solution
Try changing the Regional and Language settings for Date in the Control Panel to mm-dd-yyyy
ShadowITAuthor Commented:
Thanks, I was able to resolve the date format issue myself...I still need assistance with #1.  Combining the wildcard functionality with date range.  
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now