Search By date (Today)

[darwish]

hello
i have a table in my database that contains a date row having date and time.
in my form i have a search field
and when i search i am comparing my column in database to a date of format ("MM/DD/YYYY") and i'm not having any result
my problem is that when i compare this value i want the value in my database to be of format (MM/DD/YYYY") when i compare

This is the SQL statement i'm using
strSQL = " SELECT Prints.print_name,Prints.print_dateon FROM Prints WHERE Prints.print_dateon = #" & Date & "#"

any help is appreciated

thank you

[recyan]

Have you tried :
WHERE (((CDate([printdate_on]))=[Forms]![Form1]![frmdtField]));

I suppose, the form field has Format set to ShortDate.

Thanks