regarding DTPicker in vb6

[coolajay]

Hi
I'm using given below code to get date between two diffrente date.

would u please sugest where i'm commiting mistake .


Private Sub Command1_Click( )
If rs.State = 1 Then rs.Close
rs.CursorLocati on = adUseClient
rs.Open "select * from member where dt between #" & Format(DTfrom.V alue, "dd-MM-yyyy") & "# and # " & Format(DTto.Val ue, "dd-MM-yyyy") & "# ", con, adOpenDynamic, adLockOptimisti c
DataReport1.Sho w
End Sub

[debasisdas]

are you getting any error message for that code ?

[lotus18]

What exactly the error or mistake are you facing?


Rey Sean