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.