Ricardo,

Thanks - I am aware of that, however, I am using SPT cursors, not views. I know of know way to get automatic "datetime-date translation" happening without a dbc.

Ken

>Hi Ken,
>
>Do the following code:
>
>SELECT myview
>DBSETPROP("myview.datefield", "field", "Datatype", "D(8)")
>
>Hope it helps!
>
>Cheers,
>
>Ricardo