Exporting dates from RR SQL to wks

[bshefshick_(Guest)]

I am using R&R SQL Version 9.0. When I export records in a report to wks, all fields look fine except the date fields. When I pull up the wks file in Excel 2000, the dates look like this: ___;___±<___?<___±<___Ê;___(The squares are filled in)__I have formatted the mm/dd/yy. ____When I export to a dbf file and pull up the file in Excel 2000, the dates work fine.

[kfleming]

Have you tried exporting to a text data file using CSV format and then opening that file in Excel?____Kathleen__R&R Support