SQL Date range query Infopath sp1

[RickH]

I have a form based on a SQL database, with a table that has records with a
datetime field.
I want the user to be able to speicify all records from x date to y date,
and have them returned in the form. I want the time portion ignored.
Using VB.NET.
I can find no reference on how to do this... anyone have any ideas??

 

[RickH]

Looks like no one has ever done this--is it even possible? Seems to be a
limitation of Infopath....

 

[Anne]

I have the same problem that you but I don't knows who do it?

Anne

 

[RickH]

I worked around it by adding a Year, Month, Day fields to the SQL database,
and wrote a sproc to parse the datetime field into its components to populate
those fields automatically...
Not exactly what I need but usable.