>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.