Hi Paul,

Just for checking, try to use the CONVERT function on the DATATIME field.
Make the select instruction of your view be something like this:

SELECT myfield1, myfield2, CONVERT(CHAR(10), myData, 121) FROM mytable


Say something,

Ricardo