I think your problem is probably that the column is a DATE, but NOW() returns a DATETIME. You probably need to CAST() one or the other.