Query for date range?

[mattboy_slim]

How do I query SQL Server 2000 for a date range, such as from July 01 to July 31. I'd like to exclude the year so that I do not have to update my page every 12 months.

Thanks in advance,
Matt

[mattboy_slim]

OK, I came up with the following:


"Select * from t_events where ev_dt_start BETWEEN 7/1/2003 AND 7/31/2003"


And at least I'm finally not getting an error, but I'm also not getting any output.

Any ideas?

[mattboy_slim]

Issue resolved.

For future searchers, here was the correct syntax:

"Select * from t_events where ev_dt_end BETWEEN '7/1/2003' AND '7/31/2003' order by ev_dt_start"