SELECT substr(dtos(ADDDATE),6) as yearmonth, * ;
FROM THREAD;
WHERE NOMEMBER=lnNumero AND NOCLIENT=lnWeb;
INTO CURSOR TEMP;
ORDER BY 1

Now you have the repartition and you can select any yearmonth from TEMP.

As long as you take all dates from THREAD for a specified user, you don't need the 1st and last date in the SELECT.

Vlad

>SELECT ADDDATE FROM THREAD;
> WHERE NOMEMBER=lnNumero AND NOCLIENT=lnWeb;
> ORDER BY 1 INTO CURSOR TEMP
>
>This will be a direct result giving me all the dates for a user in a specify forum. So, after this SQL, I now have my first date. Doing GO BOTTOM, will give the last date.
>
>There I have the first and last date which I then use for the month/year repartition.
>
>This is where I am not sure about the technique to use.
>
>Thanks.