>Hi All
>
>When using COPY TO ... TYPE XL5 or EXPORT TO ... TYPE XL5 how can I ensure that dates are converted correctly and formatted as date fields in the target XLS file? Or is there another way?
>
>TIA

Hi Jos,

I was working on the same problem recently. I found that TYPE XL5 produced dates as dates, but TYPE XLS produced them as character fields. Also if you want to have blank dates in XLS make them NULL in the table/cursor.