Edit the remote view, click the properties button. Go to Data Mapping and change the Data Type to Date.

>Now this solution sounds interesting, yes we are using remote views. This could work well until we established more control over our edits (as J suggests). However, I am unaware of the secret of changing the data type on a column in a view. How do you we do this magic feat?
>
>...tim
>
>>Are you using remote views?
>>
>>If so, you can set the data type to the fields in the view to DATE and the time portion will be dropped.