I stucked up with one query i think so simple..
I am writing one application in whcih i have to select the values between dates..
I am writing the query like this.. in VB
sql="select file_name from abc where sdate between '" & text1.text &"' and '" & text2.text & "'"
where i am getting the values in textboxes from calendar..
but this query is showing errors
pls let me know this query how to write the sql to selecct between dates.. it s urgent