The CursorAdapter will definitely do this for you. Just specify in the CursorSchema property that the DatTime field should be a Date datatype. For example:

LastName C(20), FirstName C(20), LastVisit D

Check out my CA VCX Builder for creating a ClassLib of CAs for all tables in your SQL Server database. It is loaded with comments and help at the top of the PRG file. It is free with complete source code.

http://www.mctweedle.com/downloads/cabuilder.zip


>Hi,
>
>I'm getting information from SQL Server 2000 and of course the date is coming as datetime. Someone pointed out to me that I can use cursor adapter to convert the datetime to date and still keep it updatable.
>
>This is my situation, I use SQL passthru to get a cursor which I make updatable. Now I want the datetimes to be converted to dates and STILL have the cursor be updatable.
>
>If I select the cursor into another cursor adding another field as a date that will work for me but when I do this the new cursor is no longer updatable, is there a way to make this new cursor updatable?, otherwise will cursor adapter be able to accomplish this?
>
>Thanks