Jose,
You can make the view parameters:
ldToday = date()
timestampfield >= ldToday and timestampfield < (ldToday + 1)
There are also some date functions on the server side that you can use. I don't have a SQL server lang ref handy right now.
>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.