Hi Andrews,

If you can import that file into a DBF, bring the date part into a Character field and then convert it into a date field. Lets call table MOV.DBF, the Character field charDate and the date field TgtDate:

cMonths="JANUARY  FEBRUARY MARCH    APRIL    MAY      JUNE     JULY     AUGUST   SEPTEMBEROCTOBER  NOVEMBER DECEMBER "
SELECT mov
SCAN
   nBracket1=AT("/",mov.charDate)
   nBracket2=AT("/",mov.charDate,2)
   cThisDay=LEFT(mov.charDate,nBracket1-1)
   cThisYear=RIGHT(mov.charDate,LEN(ALLT(mov.charDate))-nBracket2)
   cThisMonth=UPPER(SUBSTR(mov.charDate,nBracket1+1,nBracket2-(nBracket1+1)))
   cThisMonth=PADL(INT(AT(cThisMonth,cMonths)/2)+1,2,"0")
   REPLACE mov.TgtDate WITH CTOD(cThisMonth+"/"+cThisDay+"/"+cThisYear)
ENDSCAN

>The problem that I today am going to expose is related with the data convertion.
>The matter is the following:
>I have a file ascii, called mov.prn.
>There is information, order in records of the following way:
>11021 20 51 5/January/1999 28932
>11021 20 51 8/January/1999 28949
>11021 20 51 13/January/1999 28982
>11021 4 51 29/January/1999 29073
>How could I do it from Foxpro26, in order to pass it to DBF format?
>The greater problem has it with the date field.
>Apparently that better it work is:
>use kdx
>append from mov.prn type sdf
>But the problem with the date appears.
>TIA