[RESOLVED] Date range?

[h4x0rmx]

I have a simple DB in which the dates are stored in this format:
12-2-2008 12:00:00 AM

I need to create some reports to get the rate of some statistics, but the way I'm doing it isn't working.

I have some date ranges given by the user in format 12-2-2008.
This is my testing query... I'm probably doing something pretty stupid or just missing something small. Do I have to convert the user input to some other format?
Any suggestions?

SELECT COUNT(q.qid)
	FROM
		tr.qanswer AS q,
		tr.monitors AS m
		WHERE
			q.answer = "YES"
			AND m.evalid = q.evalid
			AND m.agent_id = 966
			AND m.Date >= '11-4-2008'
			AND m.Date <= '12-4-2008'

[devinemke]

what RDBMS are you using? mySQL? if so then the native date format is YYYY-MM-DD. it appears that you are storing your dates as strings which is why your date comparisons are not working as expected.

[h4x0rmx]

I am using MySQL and the data type for m.Date is date, there's another field that I could use and it is data type timestamp.
Any suggestions?

[devinemke]

SELECT * FROM table WHERE datefield BETWEEN '2008-11-04' AND '2008-12-04'

[h4x0rmx]

Thanks! I was missing the YYYY-MM-DD format!