SELECT MyTable
INDEX ON DTOS(ddebut) TAG MyTable
SCAN
SKIP
IF .NOT. EOF()
d_repldate = ddebut-1
SKIP -1
REPLACE dfin WITH d_repldate
ENDIF
ENDSCAN
>Hi all,
>
>I have a table :
>
>Sample
>
>ddebut D dfin d
>01/02/2002 { / / }
>01/04/2004 { / / }
>01/07/2004 { / / }
>
>I would like that the end of a recording precedes the beginning by the following recording.
>
>ddebut D dfin d
>01/02/2002 {31/03/2002}
>01/04/2004 {30/06/2004}
>01/07/2004 { / / }
>
>
>Thank in advance....
>
>
>bernhart
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.