I have a date/time field in my SQL Server database. When I create a remote view in my fox database, it comes through as a date/time also. Not a problem, you may think!

Unfortunately the users do not wish to see the time portion of the field.

Is there any way of getting fox to ignore or hide the time portion of the date/time field without any extensive recoding? Any advice would be greatly appreciated.