2. PHPRunner General questions
  3. to view/edit current month data only
This topic is locked

to view/edit current month data only

 		8/19/2005 00:14:56
PHPRunner General questions
D
 dxoxb author

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 ?
Sergey Kornilov admin 8/19/2005

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 author 8/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 ?
Sergey Kornilov admin 8/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.