>What about a remote view. That'll allow you to map the date/time to a date field.

George. Suppose I create a DBC with a remote view in it. Is there a way to dynamically change the WHERE clause (ie. the filter) of that view to a new expression and requery it? CURSORSETPROP and DBSETPROP don't let me change the SQL.