This would do it if you are just comparing two dates: $max_date = ($date1>$date2?$date1:$date2);
It's just using the one line form of an if statement. Note that the function is incorrect if they date are equal.
On Tuesday, July 15, 2003, at 12:36 PM, Miguel Perez wrote:
I was wondering if there is a date function to get the older date between two dates?. Or smething that indicates me that one date is older than the other one.
I know that I have the function YEAR,MONTH,DAY and I can use them, but I don't know if exists a function that can do the same.
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]