>I want to select a range of records by date and group them by weeks.
>Any suggestions ???
Here is some untested code, but I think you will get the idea...
SELECT week(startdate) as wdate, atable.* ;
FROM atable ;
GROUP by 1 ;
INTO CURSOR cResult
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