Probelm with sql script

[brentwood]

I have been using a sql script to for list of outstanding payments. I just updated to 7.4.16. Now the result shows System.Byte[] for "last statement date" and "due date". I check the data of "DateSent" in "statement" table. It seems O.K. to me. Does anyone know what is going on? Thanks.

SELECT CONCAT(pat.LName, ', ', pat.FName) AS "Patient",
DATE_FORMAT(MAX(s.DateSent),'%m/%d/%Y') AS "Last Stmt Date",
DATE_FORMAT(DATE(ADDDATE(MAX(DATE(s.DateSent)), INTERVAL 365 DAY)),'%m/%d/%Y') AS "Due Date",
pat.estbalance /* patient estimate balance not the whole family */
FROM patient pat, statement s
WHERE s.PatNum = pat.PatNum AND DATE(s.DateSent) > DATE(ADDDATE(CURDATE(), INTERVAL -365 DAY))
AND s.Mode_ = 0 /*mail*/
and pat.estbalance > 5 /* this is patient balance not family */
GROUP BY pat.PatNum
ORDER BY MAX(DATE(s.datesent)) DESC, "Patient";

[wjstarck]

Have a look at this thread:

viewtopic.php?f=1&t=3149