Overlapping Days | Matthew Bellew | 2011-11-09 13:17 |
Status: Closed | ||
Without look at this too hard, the COALESCE expression seems suspect. Since CURDATE() is never NULL, COALESCE(CURDATE(), h.enddate) will always equal CURDATE(). I think you need to switch the arguments. |
||