2. PHPRunner General questions
  3. 2 dates
This topic is locked

2 dates

 		5/15/2007 12:23:25 AM
PHPRunner General questions
E
 evan_ad2000 author

Hi,
I was wondering, for this:
http://www.info-discuss.com/IFT_Final/_ite...earchField=date
This searches for records after 15/05/2006. Is there any way I can add another date to the URL so that the search is limited between 2 dates?
Thanks,

Evan
J
 		Jane 5/15/2007

Evan,
you can do the following:

  • edit your query on the Edit SQL query tab.

    Here is a sample:

    select date,

    date as date2,

    ...

    from TableName


  • check off date2 field on the Advanced search page only on the Choose fields tab.


  • build your project, open generated templates/..._search.htm file, find this code:

    <form method="POST"





and replace it with this one:

<form method="GET"


  • then run your search on the Advanced search page and save url for this search.