2. PHPRunner General questions
  3. Where record-date is greater than or equal to today
This topic is locked

Where record-date is greater than or equal to today

 		3/23/2006 4:39:13 PM
PHPRunner General questions
S
 slhawk98 author

I need to know how to get phprunner to display all items where the record-date is greater than or equal to today.
Example:

mysql> SELECT CURDATE() - 1;

-> '2006-03-23'
Sergey Kornilov admin 3/24/2006

Hi,
you can edit SQL query manually on the Edit SQL query Tab.

See my example:

select fieldname1,

fieldname2,

fieldname3

from TableName

where fieldname2>=now()