Custom SQL queries

[RickH]

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)

 

[RickH]

Using VB.NET.......and Visual Studio 2003. I sure hope the new version
of VS has a parse fuction that converts InfoPath datetime to SQL
datetime---hate writing my own conversion functions..

 

[RickH]

I take it either this is not possible to do or no one knows how to do
it???