Dataset filter problem

hlybbi · Mar 20, 2006

i am having trouble filtering datatable

how can i do this WHERE theDate BETWEEN #1.1.2000# AND #1.1.2002#

this work
TestBindingSource.Filter = "theDate=#1.1.2000#";

Best regards Hlynur

http://www.xodus.net

hneal98 · Mar 21, 2006

change this

Code:

theDate BETWEEN #1.1.2000# AND #1.1.2002#

to this

Code:

 theDate >= #1.1.2000# and theDate <= #1.1.2002#

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Dataset filter problem

hlybbi

Programmer

hneal98

Programmer

Similar threads

Part and Inventory Search

Sponsor