MSFlexgrid Problem

[Alexus]

Hello,
I have a flexgrid I use for a search form.
I can return text values fine but cannot return dates
This works fine

strsearchService = "Select RO,Vehid,TransDate,Comments from ROHeader where VehID = '" & txtVehicle & "'and SourceID = 23 order by RO DESC"

But when I try to return a date within a range like

strsearchP1 = "Select RO,Vehid,TransDate,Comments from ROHeader where WHERE [TransDate] BETWEEN #" & txtDateFrom & "# AND #" & txtDateTo & "# order by RO DESC"

I get Hierarchial flexgrid does not support the requested type of data binding. What is causing this?
Thanks for any help

[Hack]

That looks like a query against a database, not flexgrid.

Are you running this against an Access Table?

[si_the_geek]

It looks to me as if your date values are not specified correctly (even if you are using Access).

For an explanation of the correct way to do it, see the article How do I use values (numbers, strings, dates) in SQL statements? from our Database Development FAQs/Tutorials (at the top of the Database Development forum)


In addition to that, carefully re-read your second statement.. there is a duplicated word in there.

[Alexus]

Yes, it is a query against a database which returns the rows to a flexgrid.
At least I think that's how it works. and yes it is an access table.
I will take a look at your suggestions.
thanks