Date Format

[accessman2]

Hi,

----mdb file
if DCount("*", "tbl1", "Format([Date Submitted],'m/d/yyyy') < #" & DateAdd("d", -2, Format(Now, "m/d/yyyy")) & "#") > 0 then
.............................
end if

-- ADP
if DCount("*", "tbl1", "CONVERT(Char(10), [Date Submitted], 101) < '" & DateAdd("d", -2, Format(Now, "m/d/yyyy")) & "'") > 0 then
......................
end if

I have a question, Can we pick up the date section of the Date Submitted to compare to the current time?