Does DATEDIFF only work with actual dates input i.e ('2004-12-05'............
Or couldn't I do : Select DATEDIFF (StartDate, EndDate) AS DaysBtwn from mytable? (StateDate,EndDate are date columns from db) I'm generating a syntax error on this above. Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]