Dear all,
I have FrmDt and ToDt as datetime column in sql server2000. I am comparing dates in these columns with two datetimepicker like this-
SQL query- WHERE FrmDt>='" & dtp1.Value.Date & "' AND ToDt<='" & dtp2.Value.Date & "'
In Query Analyzer, I tried this FrmDt>='01/21/2015' AND ToDt<='01/21/2016'. Its giving me correct output. But I am not getting the output in Vb.net? Anything missing?
Thanks and regards