How to get data between two dates with month/date in query

[r937]

can you please try something similar to this –

How to compare two dates saved in string format

[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'