DCOUNT with Date field

[sal21]

i ned to trap a date field in this piece of code, how to?

Code: Select all

  If DCount("*", strTable, "date1=" & Chr(34) & rst!date1& Chr(34)) > 1 Then

note:
date1 have a date short property
the code is an old code

[HansV]

Date values must be formatted using US format mm/dd/yyyy or international format yyyy-mm-dd, and enclosed in #, not in Chr(34):

Code: Select all

  If DCount("*", strTable, "date1=#" & Format(rst!date1,"yyyy-mm-dd") & "#") > 1 Then