I thought this would work after looking at about 10 threads on Subtracting Dates...and the Interval function...but to no avail....

I have the colum "entry_time" as a "datetime" format in my table...

can anyone provide a tip?

SELECT nhm_associate, COUNT(nhm_associate) AS totalcount FROM registration_table GROUP BY nhm_associate WHERE entry_time > DATE_SUB(CURDATE(), INTERVAL 14 DAY)