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