Showing comments from the last 6 days only

Hi,

I found in /models/blog.php that the getBlogComment function has a query to retrieve comment and tried to add the following but it does not have effect.

Can you help me with the syntax please?

if ($lite) {

			$query = 'SELECT a.* FROM `#__easyblog_comment` a';

			$query .= ' LEFT JOIN #__users AS c ON a.`created_by` = c.`id`';

			$query .= ' WHERE a.`post_id` = '.$db->Quote($id);

			$query .= ' AND a.`published` = 1';

$query .= ' AND a.' . $db->quoteName('created') . ' >= DATE_SUB(' . $db->Quote($now) . ', INTERVAL 6 DAY)';

Kind regards,

Matt