>
>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