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"

[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

[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

Thanks a Lot

[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.