You said credit goes to Vlad, but I see no credit.

Where's his stars, man?????


>You're the fastest, so the credit goes to you :) As the data didn't even changed but after the "IN auth", it does it all prefectly. Thanks!
>
>Chuck
>
>>Add at the end of the command ' IN auth'
>>If the current alias is org, recod will move there. Replace uses the current alias as a main recordset, if 'IN' is not specified. If eof() in current alias, for example, it will not replace a field in another alias despite you specified it and despite the target alias is not eof().
>
>>>

>>>REPLACE auth.end WITH DATE() FOR ;
>>>     auth.organization = org.organization AND ;
>>>     (auth.end > DATE() OR EMPTY(auth.end))