>select str(year(datefield),4)+str(month(datefield),2) as yearmonth ... bla,bla... group by yearmonth

Yes, this was my first try.

However, the group by does not give a direct result. So, that's why I was focusing on another method. I have a tag on the date of the message and I would like to use this technique.

So, for example, I start by doing a SQL like this:

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.