Home Posts Topics Members FAQ
Post your question to a community of 467,923 developers. It's quick & easy.
Hi, Wrap Date Conditions with #: For Access : rs.Open "SELECT * from accounts where date=#" & mydate & "#", con, adOpenStatic, adLockOptimistic For Oracle : rs.Open "SELECT * from accounts where date=To_Date('" & mydate & "','m/d/yy')", con, adOpenStatic, adLockOptimistic REgards Veena
ya its working Thanks a Lot
Sign in to post your reply or Sign up for a free account.