InfoPath date picker

[aerobar2]

I have a simple Access 2003 table that has a date field (short), I want to
query records from this table using the date picker. When I set up my query
in an InfoPath form, it returns ALL records and ALL dates. I just want the
date selected - how do I do this?

 

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

Date pickers use a special format behind the scenes (see
http://enterprise-solutions.swits.net/infopath/date-time-basics-infopath.htm).
This format is probably not the same as what is stored in your Access table.
You need to use the same format in your query field and Access table to be
able to search.

 

[aerobar2]

Yes! I set the format of the Date field in my Access table to yyyy-mm-dd and
it worked! Thank you