HELP!!

I have a remote view that pulls all records for a specific date such as today 3/4/02. MS SQL is saving the date as a datetime such as 03/04/02 2:00 PM. My view always comes up empty unless I go into MS SQL and erase the time portion of the date time field. When I do this everything works. I tried all combinations of CTOD and DTOC. I think I need to use an SQL date function of some sort.

Any ideas?

Thanks!

Jose