- Edited
I am trying to install a column that displays the Age of the Tickets in daysThese links have helped to inform but they do not work with the date difference as in : Date of opening ticket and the Now timehttp://www.sudobash.net/osticket-age-of-ticketshttp://forum.osticket.com/d/discussion//a-better-ticket-list#latesthttp://forum.osticket.com/d/discussion//append-a-created-ticket-status-form-field-to-an-already-existing-column-in-the-main-ticket-view#latestOsticket Version v1.9.6MySql Version 5.5.54In "tickets.inc.php" I have made progress using "strtotime" but I get an error with the "date", The 'date' returns a value of -7200 . ( Not returning the correct value. )The Now Returns a value of 1489269600 ( current date increasing with time )Basically this is what I have done so fararound line 250 I have added$sqldate = ('date'); $newdate = date('Y-m-d',strtotime($sqldate));echo $newdate;$sqldate2 = ('today UTC');$newdate2 = date('Y-m-d',strtotime($sqldate2));echo $newdate2;$timeopen = (strtotime($newdate)) ;$age_date = (strtotime($newdate2)) ;Then around line 500 (this is dynamic as I have a lot of construction text at present ) I simply subtracted them.<td align="center" nowrap><?php echo ((($age_date) - ($timeopen ))/ 86400 ) ; ?></td>Apparently strtotime does not have a problem with USA and European dates ,I quote :' Dates in the m/d/y or d-m-y formats are disambiguated by looking at the separator between the various components: if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) or a dot (.), then the European d-m-y format is assumed.' Can anybody help in moving this forward ?All help will be MOST graciously appreciatedthanksAndy