parameter date in sql
Posted on 2003-02-24
hope can reply me about this
i have Calendar and click on it to put the date in 2 textbox and then click button to get the data between this 2 date for example "10-january-03" and "10-march-03"
the problme my sql parameter accept only numbers??
and another thing it execute "month-day-year"
please tell me how can use date like"10-january-03"
in the parameter
Private Sub Command4_Click()
rec2.Open "select * from entry " & _
" where d Between #" & Text2 & "# And #" & Text3 & "#", cnn, , , adCmdText
greatfull for any reply