General information
Category:
Coding, syntax & commands
What level of detail do you want? I understood you need only a count by year+month. Do you need all records? I think I didn't understand what you want to obtain.
Vlad
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only