MySQL - 6 months ago
===

I want entry from 6 month ago and today and I think I can improve this mysql query:

    WHERE (DATE(l.date_fin) BETWEEN DATE(DATE_ADD(NOW(), INTERVAL -6 MONTH)) AND CURDATE())

Can you help me ?