>>I passed laHeader_Info[lnI,3] = "mm/dd/yyyy;@" but it made no difference. The dates are still 23-Jul-08
>
>Did you try just plain copy to ... XL5 ? If you have D field in VFP table, then I expect it will give you format mm/dd/yyyy automatically.
Hi Yuri,
I'm using COPY TO type XLS. I found that by using XL5 format the original name casing of the file is not respected.
I then apply the NumberFormat. I can try to not pass NumberFormat for dates, but I'm afraid the result would be the same.
Let me re-try without passing NumberFormat at all.
If it's not broken, fix it until it is.
My Blog