only show the records of current month when enter the site?

This topic is locked

only show the records of current month when enter the site?		7/8/2008 03:16:55
PHPRunner General questions
A amuro author Hi, someone advise me, please I create a report for reviewing sales, Could it present the records of current month? But users can find records of other month via search function. Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8937&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />


J	Jane 7/8/2008
	Hi, try to use following code in the List page: Before SQL query event on the Events tab: if (@$_REQUEST["a"]!="search" && @$_REQUEST["a"]!="advsearch" && @$_REQUEST["a"]!="showall") $strWhereClause = whereAdd($strWhereClause,"DateFieldName>now()");