Hi, Under the view/list feature for our transaction detail ,we want just to list the current month data only. The date field is "date". Is there a way to do it, by filtering or where ?
Hi, you can add the following WHERE clause on SQL Query tab in PHPRunner
where year(now( ))*12+month(now( )) = year(date)*12+month(date)
D
dxoxb author8/20/2005
Thanks. Will test it out Should has asked the following with the 1st post: What should we do to list the data with the "last month" and "next month" button ?
admin8/22/2005
Hi, you can do it modifying the ..._list.php page manually.
Since we don' have ready to go solution for this task we can implement this for you as the custom project.
Write to support@xlinesoft.com if you're interested.