You can use a command in your SQL statement as follows:
"convert(char(12),RM20101.DOCDATE,101)AS DOCDATE,"
This gives you just the date portion of the field "char(12)". Also, read Convert() in SQL books online. The ",101" code(s) are important.
C. W. Finch
C. W. Finch Consulting
