*!* if you need the earliest regdate Select cauktcid, DTOC(MIN(regdate)) as datum from auktlogg group by 1 into cursor cTempAuktion *!*or Select cauktcid, MIN(DTOC(regdate)) as datum from auktlogg group by 1 into cursor cTempAuktion *!* if you need the latest regdate Select cauktcid, DTOC(MAX(regdate)) as datum from auktlogg group by 1 into cursor cTempAuktion *!* or Select cauktcid, MAX(DTOC(regdate)) as datum from auktlogg group by 1 into cursor cTempAuktionThe second example of each would not necessarily provide correct results as it compares the value as a character string and not as a date. example: max("10/20/2000","01/01/2003) would return "10/20/2000", however this would suffice if you need just any date. This would be more like the original result in pre VFP8.
Select cauktcid, DTOC(regdate) as datum from auktlogg group by 1 into cursor cTempAuktion>