>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
>
>******************************************************************************
Is it DD/MM/YY or DD/MM/YYYY because I see the full year here?
ldOldSet = SET([DATE])
SET DATE BRITISH
lcDateStr = LEFT(YourLine,8)
ldDate = CTOD(lcDateStr)
SET DATE &ldOldSet
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.