>Does anyone know how to turn a DateTime type field to a Date type field in a SQLEXEC cursor, not a remote view?

Monte,

I ran into this same problem and decided to handle it in the UI. I created a textbox class that handles the TTOD() and DTOT() conversions, thus masking the time part and setting the time to 00:00:00. Could you handle your problem the same way?