Ricardo,

thanks - but that simply pulls it across as character data type - not date.

Is there not simply a way to force a grid column to display/accept only the date portion of a datetime value, while still being read/write?

thanks,
Ken


>Hi Ken,
>
>Sorry but i must have misunderstood your first message.
>Since you're using SPT cursors, you can use CONVERT function at the SELECT for getting the information that create the cursor:
>
>SELECT ..., CONVERT(Char(10), myfield, 121), .... FROM ...
>
>Cheers,
>
>Ricardo