[quote=“saddam987020, post:8, topic:200807, full:true”] Am I doing it wrong way?
[/quote]
yup
when you convert to a date, you have to compare to actual dates
AND STR_TO_DATE(CONCAT(meta_value,'/2000'),'%m/%d/%Y')
BETWEEN '2000-08-15'
AND '2000-12-15'