Error!!! Data type Mismatch (Problem in comparing 2 dates)

vishwaskothari

What is wrong in the following Statement?



Dim mydate As Date
Format(mydate, "m/d/yy")

rs.Open "SELECT * from accounts where date='" & mydate & "';", con, adOpenStatic, adLockOptimistic


It gives the Error "Data type mismatch in citerian expression"

Aug 27 '07 #1

QVeen72

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

Aug 27 '07 #2

vishwaskothari

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

Aug 27 '07 #3

hariharanmca

ya its working

Thanks a Lot

'm' will reffer Munit of time

only 'MM' or 'M' will only reffer Month of date.

Just check it.

Aug 27 '07 #4