InfoPath date picker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aerobar2 - 23 Mar 2006 18:26 GMT

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?

Reply to this Message

S.Y.M. Wong-A-Ton - 23 Mar 2006 20:14 GMT

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.
---
S.Y.M. Wong-A-Ton

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

Reply to this Message

aerobar2 - 23 Mar 2006 22:19 GMT

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

> Date pickers use a special format behind the scenes (see
> http://enterprise-solutions.swits.net/infopath/date-time-basics-infopath.htm).
[quoted text clipped - 8 lines]
> > in an InfoPath form, it returns ALL records and ALL dates. I just want the
> > date selected - how do I do this?

Reply to this Message