Hi Experts -
We're selecting clients by visit date but can't seem to get any selective results.
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=c:\CLIENT_RECORDS.mdf;Data Source = ASUSPeter\SQLEXPRESS"
rs.CursorLocation = adUseClient
rs.Open "Select * from VISITS where [visitdate] > " & DateValue(DateAdd("m", -60, Now)), cn
The data is in [9/09/2005 12:00:00 AM] format and ranges from (2001 - present). As the query stands here, it returns all the records in the table.
(Alternatively, no records when trying [<] )
Can anyone explain or fix this?