Date Comparison

[Terry]

Date stored in DB as date/time
In VBA, wish to find date that is 2/8/2010
"DateofService" = "2/8/2010" doesn't work.

 

[Stuart McCall]

Date stored in DB as date/time
In VBA, wish to find date that is 2/8/2010
"DateofService" = "2/8/2010" doesn't work.

Try:

"DateofService = #2/8/2010#"

Use hash symbols to indicate that the value is a date.

 

[Terry]

Using the following statement, I received a run-time error 13, type mismatch
on the If "DateofService" = #2/8/2010# Then line .
DateofService is a column defined as a Date/Time data type, whit a Short
Date format.
Do Until rst.EOF
Debug.Print rst("DateofService")
If "DateofService" = #2/8/2010# Then
Debug.Print rst("DateofService")
rst.MoveNext
Else
rst.MoveNext
End If
Loop
Terry

 

[Terry]

I used "DateofService" = #2/8/2010# and received a run-time error '13' type
mismatch on the If "DateofService" = #2/8/2010# line. The suggested
"DateofService = #2/8/2010#" also raised the same error.
Do Until rst.EOF
Debug.Print rst("DateofService")
If "DateofService" = #2/8/2010# Then
Debug.Print rst("DateofService")
rst.MoveNext
Else
rst.MoveNext
End If
Loop

Thanks,
Terry

 

[Jeanette Cunningham]

I haven't read the original part of this thread, but I can see the type
mismatch.
Put rst and brackets around "DateOfService"


If rst( "DateofService") = #2/8/2010#


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia