I can make a filter to limit the items in the query list, but I haven't
figured out how to populate a repeating table with items between two
dates.
Common task is to return all records between two dates that are based
on a datetime field in the SQL table.
I assume you would start by creating two datepicker controls in your
query view bound to two new fields that belong to neither queryfields
or datafields: myStartDate and myEndDate.
I can convert these InfoPath times to SQL datetimes with all 0's as
time.
Now how do I get these dates into the Select Between statement that
will return the data to my repeating section?
(NOTE: Original form was created directly from the SQL table)