What's wrong with this code ?
When used in PWS, it works ok, but on IIS, it displays all the date greater than now.
I also tried this, w/o success :Code:rs.Source = "SELECT * FROM Information WHERE [Return date] < '" & Now & "'"
Code:rs.Source = "SELECT * FROM Information WHERE [Return date] < #" & Now & "#"




Reply With Quote