PHPJunkyard support forum

Posted: **Thu Jul 22, 2010 7:59 pm**

Script URL:
Version of script: 2.2
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

How to modify the ticket date search to ONLY show the tickets closed on that day?

Posted: **Fri Jul 23, 2010 6:31 am**

In admin/find_tickets.php try changing

Code: Select all

(`dt` LIKE '".hesk_dbEscape($date)."%' OR `lastchange` LIKE '".hesk_dbEscape($date)."%')

to

Code: Select all

`status` = '3' AND `lastchange` LIKE '".hesk_dbEscape($date)."%'

Posted: **Fri Jul 23, 2010 7:00 am**

This fix also show's the Start date of a ticket, and i wanna see only the closed date of a ticket

Posted: **Fri Jul 23, 2010 1:18 pm**

Did you remove the entire code I posted (the "dt LIKE" part)?

Note that the time ticket is closed is not stored in a dedicated database column so using the lastchange column is the best and closest alternative.

PHPJunkyard support forum

Modify the Date search option

Modify the Date search option