>>
>>Jim,
>>First you should decide on rollover year (if all 1900 then 0)
>>
>>set century to 19 rollover 2
>>set date to mdy
>>replace all datefoal with ctod(trans(foaldate,'@R 99/99/99'))
>>
>>Cetin
>
>Hi Cetin, Gregory, Hilmar
>
>Thanks, this works and I now understand how it works now.
>
>Do you know if the .dat file is able to store dates in the same format as a vfp table.
>
>If so then the supplier could use this type and I wouldn't have to do a conversion.
>
>I was going to ask them but thought I'd check first to see if it was even possible.
>
>Thanks all for the help.
>
>Jim

He could cotinue to store as text but include century. If he does in YYYYMMDD format that's exactly how VFP holds date in dbf. Append from ...SDF would directly work.
Cetin