Thank's Sergey,
You are right. The same solution was provided by Elmer Adkins. You will get one star.
>>Hi All,
>>
>>How to get this working in VFP8 without setting ENGINEBEHAVIOR TO 70 ?
>>
>>
Select cauktcid, DTOC(regdate) as datum from auktlogg group by 1 into cursor cTempAuktion
>>
>>I want to have one record for each cauktid in table auktlogg with the date.
>
>From which record this date should come? If you don't care or it's the same for cauktcid than you can use MIN() or MAX() function.
>
Select cauktcid, MAX(DTOC(regdate)) as datum from auktlogg group by 1 into cursor cTempAuktion
/Torgny