>I'm using 2.6 (No chance for upgrade at this moment).
>
>I have:
>
>use table
>copy to xlstable type xls
>
>However, in the temp table, the year is 4 digits, after the copy, in the xls the year is 2. Is there anyway to mend this?
>P.S. I have century = on.
>
>Thanks,
>Sunshine

Hi,

Convert Date to string with 4 digits for year, then run copy to xlstable type xls.

HTH