>Is there any way in VFP 5.0 to convert the contents of a field to a different value during an APPEND FROM statment. I have to append data from an SDF file with dates in the format "CCYYMMDD" (ie "19980413"). I would like to automatically change these to a date format.
>Could I use TRIGGERS ?
>
>Thanks in advance,
>Alec Dearden.
Alec,
If just for that conversion, VFP does that automatically and wait SDF date format to be in YYYYMMDD format.
Cetin