lcDate='04/07/2008 1054AC PRESIDENTE EPITACIO - PRESIDENTE EPITACIO/SPConferi'
?Date(Val(substr(lcDate,7,4)),Val(left(lcDate,2)),Val(Substr(lcDate,4,2)))
>The date is in DD/MM/YY format as text below
>
>I already have the line number
>
>I was thinking about something as:
>
>If line contains "2008" or "2009" or "2010", get the the year
>and also contents at its left side and then convert it to date with ctod ()
>
>Can anybody help me with this line, or is there a more smart solution ?
>
>Thanks
>
>
>
>piece of TXT file
>
>**********************************
>
>04/07/2008 10:54AC PRESIDENTE EPITACIO - PRESIDENTE EPITACIO/SPConferido
>
>******************************************************************************